Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello - Excel 2003-
THis is my formula =IF(M18=" "," ", M18+60) In Cell M18 person will enter a date Cell M 19 is formated as date ( 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 correct this so that if M18 is blank them M19 is blank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
blank date shows up as s 1/0/00 | Excel Worksheet Functions | |||
Blank Date | Excel Worksheet Functions | |||
Date changes to ### when next cell is blank - why? | Excel Discussion (Misc queries) | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions |