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
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - May 3, 2013 at 12:41 PM
Related:
- Creating an If function using dates
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Agp function - Guide
- Clapper sorry this function is temporarily unavailable ✓ - Facebook Forum
2 responses
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
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
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
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
May 3, 2013 at 12:41 PM
Hi Dawn
Thank you for the feed back.
Kevin
Thank you for the feed back.
Kevin
May 3, 2013 at 11:00 AM
Kind regards
May 3, 2013 at 11:25 AM
Kind regards
Dawn