Today number of days between a project start date and todays date

Elise Coyne

Hi All,

I have what I am sure to be a simple formula yet can't figure this out. I need a formula to calculate the number of days between the project start and today's date. So that every day I open the sheet that number will change pending days the project is still active/ open.

Thank You!

Purnima Gore

Hi

Use the =today() in the cell and that will update everyday.

There are a number of formulas you can use. With using [Finish]-[Start] when I used 14 Oct as the start and 14 Oct as the finish the result was zero (0). Using netdays gave the answer of 1 which would mean you have spent one day on the project and that would probably be a better one to use (especially if these days are billed)

Kind regards

Purnima