Calculate Calendar Days from Start Date + Workdays

Ramsay Zaki

I would like to calculate the # of calendar days given the following information:

• Start Date
• Work Days

I know the "workday" formula will give me the end calendar date but I don't want the actual date. I am looking for the # of calendar days.

For example:

• Start Date = 1 Jan 2019
• Work Days = 11
• Resulting Calendar Days = 15

Paul Newcome

See if this does the trick for you...

 

=NETDAYS([Date Column Name]@row, WORKDAY([Date Column Name]@row, 11))

L_123

=NETDAYS(StartDate@row, WORKDAY(StartDate@row, Workdays@row))

 

Try that