Condition formatting with dates

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Good afternoon,

I'm building a spreadsheet, It has dates when a certain training has been completed. I would like one column basically to say a certain class is due Either every 24 months or 120 before the individual gets deployed. Now what format will show for those?

Thank you,

Nikki

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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