Next working day script

[Sontec]

Hi all,

I'm hoping that someone out there can help me with something thats got me stumped within an Excel macro.

We have a requirement to pull certain information from a spreadsheet when the delivery date field is the next working day. (i.e. if we run the macro on a Friay, we need to pull out Mondays deliveries)

Is there an easy way of making excel ignore weekends?

Thanks.

 

[xlbo]

You can use the Weekday function to determine what day of the week it is:

tDay = datevalue(today())
nDay = tDay + 1
Select Case nDay
Case is 1 or 7
'Weekend
Case Else
'not Weekend
end select Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[sdraper]

Check out the WorkDay function. The info below is direct from Excel help:
Returns a number that represents a date that is the indicated number of working days before or after start_date. Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed. To view the number as a date, click Cells on the Format menu, click Date in the Category box, and then click a date format in the Type box.
Do a search for WorkDay function in Excel Help for more info...
Hope this helps,
sdraper

 

[sdraper]

Oooops... I think I misunderstood your question. Workday may not work for what you want. Sorry!
sdraper