Creating an If function using dates

Solved/Closed
dawnski333
Posts
2
Registration date
Friday May 3, 2013
Status
Member
Last seen
May 3, 2013
- May 3, 2013 at 08:31 AM
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
- May 3, 2013 at 12:41 PM
Hello
I am trying to formulate an if function, should the date in the cell be less than six months old from today's date the font is red, should the date in the cell be older than six months then the font is green. If you have any ideas, it would be much appreciated. I am trying to organize orders for staff, arranged alphabetically, so thought a filter may make me miss some orders. Any ideas would be appreciated.
Kind regards
Dawn

2 replies

Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
May 3, 2013 at 09:39 AM
Hi Dawn

Hopefully I have understood your question, the dates are going forward from today is that correct!
For the conditional formatting rules.

Assuming your data is in column A, select column A, conditional formatting.

A: If date is less then today + 6 months. In other words: Between today and today plus 6 months.
=AND($A1>=TODAY(),$A1<=EDATE(TODAY(),6))
Apply the format for your font.

B: The date in column A is greater then today + 6 months.
=AND($A1>EDATE(TODAY(),6))
Apply the format for your font.

If it is the other way from today the the formulas will have to be adapted.

Kevin
1
Dear Kevin, trust me to over complicate things, your solution is brilliant, conditional formatting really obvious. Thank you for your time.
Kind regards
0
dawnski333
Posts
2
Registration date
Friday May 3, 2013
Status
Member
Last seen
May 3, 2013

May 3, 2013 at 11:25 AM
HI Kevin, I forgot to mention a thank you for the brilliant formula.
Kind regards
Dawn
0
Kevin@Radstock
Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
May 3, 2013 at 12:41 PM
Hi Dawn

Thank you for the feed back.

Kevin
0