Help!

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

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  Is there a page turn transition in powerpoint 200..  
Author Message
RR
External


Since: Jul 26, 2006
Posts: 14
PostPosted: Tue May 26, 2009 5:12 am    Post subject: Calculate a future date, not including Sat/Sun or Bank Holidays
Archived from groups: microsoft>public>excel>misc (more info?)
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
Back to top
Sean Timmons
External


Since: Dec 17, 2006
Posts: 372
PostPosted: Tue May 26, 2009 5:27 am    Post subject: RE: Calculate a future date, not including Sat/Sun or Bank Holidays [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Use the WORKDAY() function for this. If not available currently, you may
need to go Tools > Add Ins... > Analysis Toolpak to see it.

"RR" wrote:

> 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
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum