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!

Rowena Bataille
Rowena Bataille ✭
edited 12/09/19 in Archived 2017 Posts

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. 

 

Thanks in advance

· Share on FacebookShare on Twitter

Comments

  • Jose Joaquin Pastor
    Jose Joaquin Pastor ✭

    Hi Rowena,

     

    try with =NETWORKDAY(Today(),Date)

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

     

    Regrets, Jose.

    · Share on FacebookShare on Twitter
  • Rowena Bataille
    Rowena Bataille ✭

    Great! it works thanks Jose!!

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories