Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates-Conversion
I am trying to have Excel look at two cells and verify if they are =. The
problem is one is formatted as a number and the second is formatted as a date. How can I make it look at the number as a date? A1 B2 2002 1/1/2002 2003 1/1/2003 2004 1/1/2004 I need to return a value from B3 if A1 is = to B2, but right now I am not comparing a date to a date, and when I try to convert 2002 to a date, it converts to 1905. Please help. Thank you, Lisa12 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion of dates | Excel Discussion (Misc queries) | |||
Day Conversion | Excel Worksheet Functions | |||
CONVERSION | Excel Discussion (Misc queries) | |||
Conversion | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |