# Excel formula for project dates - kind of confused!!

• I am working on a project at work showing steps for a particular initiative. For example, the high level task might be "Building a House". Each sub-task will be the individual steps I need to do, one at a time until I am finished. Here is the problem I am running into. See example below:

A5 contains "starting date" of 8/31/2013, B5 shows "date completed" of 9/22/2013, C5 will need to show DAYS completed and D5 DAYS remaining.

I need to come up with a formula that will update C5 and D5 automatically and than stop when we have reached the "date completed". But if today comes before the "starting date" I want it to show a value of 0 in C5.

I have other tasks that have a "starting date" of late July so those have already started. I still need D5 to stop at 0 zero when that step is done.

HOPE SOMEONE CAN HELP ME!!!

Thank you :)))

• Re: Excel formula for project dates - kind of confused!!

Hello and welcome.
C5
=IF(TODAY()<=A5,0,TODAY()-A5)
D5:
=B5-A5-C5
or
=IF(A5>B5,0,B5-A5-C5)

• Re: Excel formula for project dates - kind of confused!!

In another cell of your sheet, enter the following formula. (I used F5) =today() That enters today's date in that cell. Then you use that cell to figure your two needs, so for days completed it would be =IF((\$F5-\$A5)<0,0,\$F5-\$A5) For days remaining it's the same thing, only =IF((\$B2-\$F2)<0,0,\$B2-\$F2) That way both return 0's when needed.

• Re: Excel formula for project dates - kind of confused!!

Or you can do what the post before me did, adding today() to the actual formula and be much more efficient!

• Re: Excel formula for project dates - kind of confused!!

I think that worked. It looks so simple, but it really threw me for a loop this morning. THANK YOU!!!!

• Re: Excel formula for project dates - kind of confused!!

Quote from GreekCPA;678867

I think that worked. It looks so simple, but it really threw me for a loop this morning. THANK YOU!!!!

You are welcome

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!