Convert workdays to calendar days?

  • Thread starter Thread starter Cara
  • Start date Start date
C

Cara

Is there a worksheet function that will convert number of
workdays to calendar days. So for example I want to know
what the date would be for 9 work days after July 31 2004.
 
Try

=WORKDAY(A1,9)

where A1 holds the date,
you can create a list of holidays as well and use it as

=WORKDAY(A1,9,holidays)

syntax is

WORKDAY(start_date,days,holidays)
 
Hi Cara

if i'm understanding you correctly i think you're after the workday function
(i think it's in the Analysis Took-pak Add-in)

=WORKDAY(StartingDate,NumberofDays,holidaystotakeintoaccount)

so in your case
=Workday("7/31/04",9)
will return
08/12/04

Cheers
JulieD
 
Back
Top