How to create a count down formula
Solved/Closed
Fusion3
Posts
1
Registration date
Friday May 22, 2009
Status
Member
Last seen
May 23, 2009
-
May 23, 2009 at 06:02 PM
Rogue - Apr 18, 2012 at 02:58 PM
Rogue - Apr 18, 2012 at 02:58 PM
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.
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.
Related:
- How to create a count down formula
- How to create @ in laptop - Guide
- Number to words in excel formula - Guide
- Create skype account with gmail - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Create snapchat account - Guide
2 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 24, 2009 at 11:53 PM
May 24, 2009 at 11:53 PM
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 ...
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 ...
Apr 18, 2012 at 02:58 PM