date range

  • Thread starter Thread starter keshia
  • Start date Start date
hi
if you have a date in F3 and compared that to today,
=IF(F3<TODAY(),TODAY()-F3 & " Days early",F3-TODAY() & " Days Late")

regards
FSt1
 
I am a beginner at excel and very confused, if cell h7 is my bday and i7 is
the date I recieved it what would it look like. I figured from your example
it would be
=IF(I7<H7(),H7()-I7 & " Days early",I7-H7() & " Days Late") and thats not
working.

Thanks so much for your help
 
Back
Top