workdays calculation

  • Thread starter Thread starter ExcelBeginner
  • Start date Start date
E

ExcelBeginner

I have a date in cell A1
Cell b I want to put a number of days in the future
cell c I want Excel to display the date

(I have placed my holidays in range h1:h13)

So how do I write this to display based on workdays in future?

Thanks!
 
Hi ExcelBeginner!

=WORKDAY(A1,B1)

WORKDAY is an Analysis ToolPak function. If the formula above returns
#NAME? then use:

Tools > Addins
Check "Analysis ToolPak"
OK

You may need the installation CDROM.

If you put a list of holiday dates in a range that you name
"Holidays", WORKDAYS will exclude those dates when calculating the
future date as long as you use:

=WORKDAY(A1,B1,Holidays)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks!
Norman Harker said:
Hi ExcelBeginner!

=WORKDAY(A1,B1)

WORKDAY is an Analysis ToolPak function. If the formula above returns
#NAME? then use:

Tools > Addins
Check "Analysis ToolPak"
OK

You may need the installation CDROM.

If you put a list of holiday dates in a range that you name
"Holidays", WORKDAYS will exclude those dates when calculating the
future date as long as you use:

=WORKDAY(A1,B1,Holidays)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Back
Top