Search : in
By :

How to create a count down formula

Last answer on Sep 27, 2009 9:10:09 pm BST Fusion3, on May 23, 2009 11:02:51 pm BST 
 Report this message to moderators

Hello all

I'd be grateful if anyone could advise on a formula to highlight a cell which would change colour 30 days before the expiry date. I believe this would be a conditional formatting.
Say I have a date in Cell A1, which is the expiry date of a training certificate eg 07/3/2010, I would like the cell to change colour to red 30 days before expiry to remind me to book refresher training.

If the cell could count down in months also, that would be a bonus but not essential.

Many thanks for any help offered.

Configuration: Windows XP
Firefox 3.0.10

Best answers for « How to create a count down formula » in :
I need help creating an Excel formula Show
Creative webcam (Solved) Show
Download PDF Creator Show Supports Windows 7 Beta PDFCreator is a free tool to create PDF files from almost any application that can print. It also possesses options of security allowing to code the PDF to protect their reading. PDF Creator also allows to create images...
Installation of Firefox 2.0+Java+flash ShowInstallation of Firefox 2.0+Java+flash with command line Introduction Firefox Installation Creating Environnement Download firefox and signature Firefox Installation Using Desktop Icon For Gnome For KDE From the menu PLUGIN...
Create a Skype account ShowCreate a Skype account How to create a Skype account? If you do not have Skype, download it and install it, the following window will appear after the installation finished: If Skype is already installed, run it and click Do not...
Create an iTunes account without credit card ShowCreate an iTunes account without credit card Itunes the default application for the synchronization of iPod, iPod Touch and iPhone requires creating an account to use, especially in order to download applications. However, when trying...
Download The Logo Creator ShowDescription The logo creator was designed by Laughingbird Software Groups. The application is based on the creation of logos. Also, the application is available for everyone; no knowledge requirements needed to use it. Logo Creator is simple and...
Download ArcSoft Print Creations Show
Download Roxio Easy Media Creator Show
Creating a local area network ShowWhy set up a local area network? When you have several computers, it can be convenient to connect them to each other to create a local area network (LAN). Setting up such a network costs very little, contrary to what people may think. Here are a...
Creating a LAN ShowWhy set up a LAN? If you have several computers, it may be worthwhile to connect them in order to create a local area network (LAN). Setting up such a network is much less expensive than what you might think. Here are a few ways you might benefit...
Creating an ad hoc WiFi network ShowPresentation of the ad hoc WiFi network If you have two or more computers equipped with wireless adapters (WiFi cards), it is possible to easily connect them in a network by setting up a so-called "ad hoc" network, that is, a computer-to-computer...
Ask your question Reply

1

mubashir aziz, on May 25, 2009 4:53:49 am BST
  • +1

Put this condition in Conditional Formatting : Formula is : = =(A1-TODAY())<=30

If you want to count down remaining days then you have to make a separate COLUMN which will appear the day when

Suppose you want to show those days in Column C then write this formula in that column ..... it will start working when 30 or less days remaining ....

=IF((A1-TODAY())<=30,(A1-TODAY()),"")


Hope it will solve your problem. if not get back to me ...
Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

2

Fusion, on May 26, 2009 11:12:00 pm BST

Thank you very

   
Reply to Fusion

3

 liridon, on Sep 27, 2009 9:10:09 pm BST

Mirmrama jam lirdoni pre pz ju pershendese shum dhe ju du shum veq pere para se shum mit je tuj shk valla

   
Reply to liridon
Ask your question Reply
They need your help