Workday used with subtracted dates

aecross

I am trying to calculate the time in working days that we spend in the survey phase. I've subtracted the start date from the actual complete date, which worked, but enveloping that in workday gives me the #INCORRECT ARGUMENT SET error.

=WORKDAY([SSR - ACTUAL REC'D FROM SURVEY CONSULTANT]@row - [SSR - ACTUAL START]@row)

I appreciate any and all help!

Jeff Reisman

@aecross I think what you're looking for is the NETWORKDAYS function, which returns the number of working days between two dates. The syntax is NETWORKDAYS(start_date, end_date, [ holidays ])

So try this:

=NETWORKDAYS([SSR - ACTUAL START]@row, [SSR - ACTUAL REC'D FROM SURVEY CONSULTANT]@row)

Paul Newcome

I agree with @Jeff Reisman that you will need the NETWORKDAYS function, but the error you are getting from your formula is due to a syntax issue. You should have used a comma in between the two dates instead of the minus.

aecross

That worked, thank you both!