date range

  • Thread starter Thread starter keshia
  • Start date Start date
K

keshia

how to you enter a formula to determine how many days early or late
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format over Date Range 3
Counting average number of days between 2 dates 3
Calculating Days Late 1
Counting days between dates 11
Attendance Sheet. 2
if question 6
Formula that returns late, early or Ok accordingly to the period 2
Using IF formula with dates 0

Back
Top