| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date input to exclude weekends
Hi all,
I seem to have a problem with making my dates auto adjust itself. Here's what the problem is. I would like to have a date whereby if it is falls on a weekend to auto adjust itself to monday, but if i have a holiday adjustment, then to take into account the number of holidays and adjust accordingly. This is what i've doe so fat bu it doesn't seem to work. Function SetDate(Current_Date, Holiday_Adjustment) If Holiday_Adjustment = "T" Then Date_Adj = 0 ElseIf Holiday_Adjustment = "T + 1" Then Date_Adj = 1 ElseIf Holiday_Adjustment = "T + 2" Then Date_Adj = 2 ElseIf Holiday_Adjustment = "T + 3" Then Date_Adj = 3 End If WeekDayNum = Weekday(Current_Date) If WeekDayNum = 2 Then Date_Adj1 = 0 ElseIf WeekDayNum = 3 Then Date_Adj1 = 0 ElseIf WeekDayNum = 4 Then Date_Adj1 = 0 ElseIf WeekDayNum = 5 Then Date_Adj1 = 0 ElseIf WeekDayNum = 6 Then Date_Adj1 = 0 ElseIf WeekDayNum = 7 Then Date_Adj1 = 2 ElseIf WeekDayNum = 1 Then Date_Adj1 = 1 End If SetDate = Current_Date + Date_Adj + Date_Adj1 End Function I would appreciate any help that anyone can give. Thank you in advance. Rgds Ray |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate Payment Due Date to exclude Weekends and Public Holiday | Excel Worksheet Functions | |||
| Exclude Weekends | Excel Worksheet Functions | |||
| Date count to exclude weekends | Excel Worksheet Functions | |||
| Exclude Weekends | Charts and Charting in Excel | |||
| Date Calculation to exclude weekends | Excel Worksheet Functions | |||
Threaded Mode
