| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validate date in Excel as weekday
I am trying to find a way to validate a date entered in Excel as a weekday.
It would be helpful to warn the user if they try to enter a Saturday or Sunday date and possible holidays. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate date in Excel as weekday
Dim mydate As String
mydate = Format(Date + 2, "dddd") If mydate = "Saturday" Then msgbox="Saturday Entered" If mydate = "Sunday" Then msgbox = "Sunday Entered" "TCUser" wrote: I am trying to find a way to validate a date entered in Excel as a weekday. It would be helpful to warn the user if they try to enter a Saturday or Sunday date and possible holidays. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Validate date in Excel as weekday
you don't really give an example of what you're doing, but here is one way,
with the date entered in A1 If Weekday(Range("A1").Value, vbMonday) 5 Then MsgBox "weekend" End If -- Gary "TCUser" wrote in message ... I am trying to find a way to validate a date entered in Excel as a weekday. It would be helpful to warn the user if they try to enter a Saturday or Sunday date and possible holidays. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to compute date of next weekday? | Excel Discussion (Misc queries) | |||
| calculating weekday date | New Users to Excel | |||
| convert weekday date to the next sunday date | Excel Worksheet Functions | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| Getting weekday for a date | Excel Programming | |||
Hybrid Mode
