Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
When running the following code today (Friday, 12/1/2006), I get a message box with tomorrows date in it: msgbox dateadd("w",1,date()) using the "w" for weekday, what is the definition of "weekday"? I was assuming that "weekday" meant M-F, not Sat or Sun. I'm trying to get this so it will show the following Monday's date if it is run on a Friday. Running it on a M-Th will just show the date of the next day. What is going on here? How can I get this to skip the weekends? -- Thanks for any help anyone can provide, Conan Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dateadd function | Excel Discussion (Misc queries) | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
Using DateAdd Function with cell values | Excel Discussion (Misc queries) | |||
Using DateAdd function with cell values. | Excel Programming | |||
DateAdd function | Excel Programming |