Date showing 00/01/1900 and formula issue

[exced]

Hi,

I want to create a project management template with timelines.

I want to input in column C the start date of the project and in column E the amount of days.

From that, I want to have the End Date autofill in column D and to create a timeline.

So far when I try to drag my formula down the file, it creates a timeline even through there's no date inserted.

Help!

[Aardigspook]

The problem is when your formula in the calendar find a blank in column C, that's less than the date in row 7, but then the forced blank "" in column D is counted as text which Excel treats as greater than a number, so the AND comes out as True.
To avoid this, add a check that there's a date (a number) as well. In H9:

=IF(AND(ISNUMBER($C8),$C8<=H$7,$D8>=H$7),1,0)

Hope that does what you need.

[exced]

Thanks!

1 more thing;

If I remove the data in the Duration column, is there a way to remove the info from the End Date column and therefore reset the timeline ?

Thanks

[Raphaelp]

Another option:

=IF($C8="","",IF(AND($C8<=H$7,$D8>=H$7),1,0))

[Raphaelp]

You can put this in column D:

 =IF(OR(C8="",E8=""),"",C8+E8)

and the timeline formula needs to be changed to this:

=IF(OR($C8="",$E8=""),"",IF(AND($C8<=H$7,$D8>=H$7),1,0))

[Aardigspook]

If you're using my formula, then you could just replace 'ISNUMBER($C8),' with 'ISNUMBER($D8),'
combined with using Raphaelp's first formula above to blank the End Date if the Duration is removed.