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!!


    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!!!!

Participate now!

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

Register Yourself Login