formula for calculating between dates

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

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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.

• ✭✭✭✭✭✭

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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.

• ✭✭✭✭✭✭

Excellent!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!