Hey everyone,
I'm a newbie and would appreciate any assistance you all can give me!
I'm trying to figure out how to highlight a specific cell if the date value in that specific cell (returned from the formula shown below) has a date value equal to or greater than 6 months and 1 day.
The formula I'm using to calculate the length of time between two dates is the following:
=DATEDIF(B2,B3,"y")&" Year, "&DATEDIF(B2,B3,"ym") & " Months, "&B2-DATE(YEAR(B2),MONTH(B2),1)&" Days "
I look forward to being amazed!
Thank You!
Bookmarks