| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date range
how to you enter a formula to determine how many days early or late
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date range
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 "keshia" wrote: how to you enter a formula to determine how many days early or late |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date range
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 "FSt1" wrote: 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 "keshia" wrote: how to you enter a formula to determine how many days early or late |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date range
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(). -- David Biddulph keshia wrote: 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 "FSt1" wrote: 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 "keshia" wrote: how to you enter a formula to determine how many days early or late |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum If range of dates date range, sum totals | Excel Worksheet Functions | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Linear Mode
