Condition formatting with dates
Closed
Nikki L.
-
May 13, 2010 at 04:18 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 04:41 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 04:41 PM
Related:
- Condition formatting with dates
- How to clear formatting in excel - Guide
- Available memory less than 15mb condition zero - Guide
- Phone formatting software for pc - Download - File management
- After formatting computer what's next ✓ - Laptop Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 13, 2010 at 04:41 PM
May 13, 2010 at 04:41 PM
Not sufficient information to give you best answer. I don't know where this conditional formatting is coming in the picture. It seem all you need is date manipulation
Lets say A1 is last time class taken and B1 is date of deployment
Then you can use this formula
=MIN(DATE(YEAR(A1), MONTH(A1)+24, DAY(A1)), DATE(YEAR(B1), MONTH(B1), DAY(B1) + 120))
The formula is saying to the last training date, add 24 months and to the deployment date add 120 days, and return the earliest of the two resulting dates
Lets say A1 is last time class taken and B1 is date of deployment
Then you can use this formula
=MIN(DATE(YEAR(A1), MONTH(A1)+24, DAY(A1)), DATE(YEAR(B1), MONTH(B1), DAY(B1) + 120))
The formula is saying to the last training date, add 24 months and to the deployment date add 120 days, and return the earliest of the two resulting dates