Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if function and date
Hello Excel 2003
In Cell M18 person will enter a date Cell M 19 is formated as date with the following formula =IF(M18=" "," ", M18+60) ( if cell M18 is blank then blank, otherwise the date on cell M18 plus 60 days ) The problem is if I add any date to cell M18 I get the correct answer , but if cell M18 is blank I get a date February 29 1900 How Do I formula so that if M18 is blank them M19 is blank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |