Display 'Date' cell as blank instead of default year 1900

**charger100** · 11-19-2009, 04:46 PM

Three columns.
A - Date last checked
B - Due Date
C - Actual Date checked

Currently column B is formatted to Date and simply has =A+84 and will display a date 3 months in future.. Great..

However if there is no date in column A, then column B displays a default 1900 date.. Is there a way of making this blank if there is no date in col A?

Thanks in advance.....

**martindwilson** · 11-19-2009, 04:48 PM

=if(isnumber(a2),a2+84,"")

**NBVC** · 11-19-2009, 04:51 PM

TRY

=iF(a2="","",a2+84)

**charger100** · 11-19-2009, 05:12 PM

Thanks.. But doing this now - ive missed telling the whole story..
Col A - Date Completed
Col B - Date Due (in 84 days of date in Col A)
Col C - Actual Date Completed

If there is no date in A, then i want B to be blank.
If there is a date in A, then i want B to display future date i.e. =A+84
If there is a date in C then i want B to display OK

You can tell im simply a novice! Thankyou in advance.....