Networkdays formula with result as a date

Pamella Souza

I have a formula that calculates the number of business days between two dates and gives me the result in days.

Now I need the same thing, but I need the result as a date.

Here is the formula I am using for the duration in days:

=IFERROR(NETWORKDAYS([START DATE]6, [END DATE]6), 0)

Can someone help me figure out how I can get the result as a date, please?

Thanks,

Pamella.

Pamella Souza

UPDATE

I got it working with Workday, but had to add 44 days in instead of 45 to get the result I wanted for.

=WORKDAY([START DATE]@row, 44)

Cheers.