| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function using dates as cell references
I need a formula that will compare the dates in two cells and IF one date is
before the other, THEN . . . . Can Excel read a date of 12/31/05 and compare it to 1/15/06, 9/31/05, etc to give me a result? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF function using dates as cell references
Yes, providing that the dates have been entered as dates, not as text.
=IF(A1<A2,"Before","After") will work, but of course Excel won't understand 9/31/05 as a date. -- David Biddulph "Evelyn" wrote in message ... I need a formula that will compare the dates in two cells and IF one date is before the other, THEN . . . . Can Excel read a date of 12/31/05 and compare it to 1/15/06, 9/31/05, etc to give me a result? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot get VALUE function to work with cell references | Excel Worksheet Functions | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Cell Reference's when Pasting | Excel Discussion (Misc queries) | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
