Calculate Calendar Days from Start Date + Workdays

Ramsay Zaki · 10/30/18

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

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:

Paul Newcome · 10/30/18

See if this does the trick for you...

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

L_123 · 10/30/18

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

Try that

Comments