Date addition in excel

Microsoft Microsoft excel 2000 95/98/me/...
April 3, 2010 at 15:01:15
Specs: Windows XP
hi, I have a start date column and an end date column. The start date isn't known until I enter the date. The end date is 90 days later. I am able to get a result for where the start date is known but where the start date is left blank the end date is displayed as 30/3/1900. I want it to return a blank cell. Any thoughts

See More: Date addition in excel

Report •

April 3, 2010 at 16:12:04
This should be posted in the Office Forum for more help:

Home Page

Report •

April 3, 2010 at 18:56:38
As Ewen pointed out, Excel questions are best asked in the Office Software forum.

That being said, try this:

With your Start Date in A1 and End Date in A2
put this formula in A2:



Report •

April 4, 2010 at 01:17:34
Thanks, that worked!

It has now caused another issue, but more for looks rather than anything else but if there is a soloution great!

Lodged Due Date Overdue Extension
12/1/2009 3/1/2010 24 10
1/04/2010 30/06/2010
blank blank #VALUE!

the formulas I used are, yours for the 'due date' and the 'Overdue' =IF(B5-C1-E1>0,B5-C1-E1,0). B5 is the current date 'TODAY()'. C is the 'Due Date' and E is the 'Extension'

As you can see it works well when dates are inserted but returns a value error when it is blank. The formula is changed as the rows go down.

Any ideas??


Report •

Related Solutions

April 4, 2010 at 08:30:29
Please post your question in the Office Software forum.
It makes is easier for others with the same or similar questions to search.



Report •

Ask Question