#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Day count formula - simple one i guess!

edited 12/09/19

Hi there,

Does anyone know how to apply the formula:

Date - today's date = n number of days?

I am struggling with bringing today's date within the formula.

• Hi Rowena,

try with =NETWORKDAY(Today(),Date)

or if you need the weekends too =NETDAYS(Today(), Date)

Regrets, Jose.

• Great! it works thanks Jose!!

• ✭✭✭✭✭✭

Be aware that NETDAYS() may return something that at first does not make sense:

NETDAYS(TODAY(),tomorrow) = 2

where tomorrow is a real date, like 02/02/17

This is because both today and tomorrow are work days.

Also be aware that the Smartsheet Formula Examples says this about NETDAYS (incorrectly - bold is wrong)

Returns the number of days (including start and end date) between two days. Doesn't take in consideration weekends or holidays. Will produce a negative number if date_1 is chronologically after date_2.

NETWORKDAY will count a weekend day if it starts on a Saturday or Sunday (but not both) and will not count if it ends on a week.

If you are looking for calendar days and don't care about weekends or holidays then

=date - TODAY()

where date is your date cell

will do fine.

=[Start Date]1 - TODAY()

returns 1 for [Start Date]1 = 02/02/17 (assuming today is 02/01/17)

Craig

This discussion has been closed.