K
keshia
how to you enter a formula to determine how many days early or late
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
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
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
K
keshia
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
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
D
David Biddulph
Your cell references should be H7, not H7().
TODAY() is a function, and the parentheses are part of the syntax of the
function (as you'll see from Excel help for the function); H7 is a cell
reference, not a function, and it's H7, not H7().
TODAY() is a function, and the parentheses are part of the syntax of the
function (as you'll see from Excel help for the function); H7 is a cell
reference, not a function, and it's H7, not H7().