Condition formatting with dates Closed

Question

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

Configuration: Windows Vista / Internet Explorer 7.0

rizvisa1 · Answer

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

Condition formatting with dates

1 response

Similar discussions

Subscribe To Our Newsletter!