formula for calculating between dates

Jeremy Tuffin

Hi,

I am looking for a simple formula to count the difference between 2 dates in number of days.

Where 'Finish' is the completion date of project, and 'TODAY' is today's date, and the formula needs to calculate the difference between the two.

I have tired to use the following formula but it just returns #DATE EXPECTED:

=TODAY@row-Finish@row

I also tried this formula with the same result:

=NETDAYS(Finish@row, TODAY@row)

be glad of any help! 😉

Andrée Starå

Hi @Jeremy Tuffin

You don't need the TODAY column.

Try something like this.

=NETDAYS(TODAY(), Finish@row)

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jeremy Tuffin

Perfect - many thanks this has sorted it! :)

I also had the column formatted as a 'date' column. When I did the formula the first time it still said #DATE EXPECTED, so it was obviously this messing it up as well.

Thanks for your help and for removing a column from my already overpopulate sheet!

All the best.

Andrée Starå

@Jeremy Tuffin

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Jeremy Tuffin

You don't need the TODAY column.

Try something like this.

=NETDAYS(TODAY(), Finish@row)

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jeremy Tuffin

Perfect - many thanks this has sorted it! :)

I also had the column formatted as a 'date' column. When I did the formula the first time it still said #DATE EXPECTED, so it was obviously this messing it up as well.

Thanks for your help and for removing a column from my already overpopulate sheet!

All the best.

Andrée Starå

@Jeremy Tuffin

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!