Calculate a future date, not including Sat/Sun or Bank Holidays

R

RR

HI

I need to calculate a date 20 ways in the future but not including Sat, Sun
or Bank Holidays. i.e. received 01/05/09 calculated date should be 1/6/09
(date received is day 1).

Can anyone help please
 
R

Ron Rosenfeld

HI

I need to calculate a date 20 ways in the future but not including Sat, Sun
or Bank Holidays. i.e. received 01/05/09 calculated date should be 1/6/09
(date received is day 1).

Can anyone help please
Click to expand...

Look at HELP for the WORKDAY function.
--ron
 
S

Sean Timmons

Use the WORKDAY() function for this. If not available currently, you may
need to go Tools > Add Ins... > Analysis Toolpak to see it.
 
S

Sean Timmons

Use the WORKDAY() function for this. If not available currently, you may
need to go Tools > Add Ins... > Analysis Toolpak to see it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working out a future date with formulas 3
Count if the the critera is met then half it 5
Problems with date calculations (bank hols etc) 3
Calculation Project Date skip Sun and Sat 3
Tricky Date calculation: How to calculate a future date 9
Conditional Formatting & UK Bank Holidays 5
Future date with six day week including holidays 1
Payroll 1

Top