| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date
I have a series of dates in column f, and the formula is
DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)), but I need to check if this date is a weekend or weekday. Let us say 06/18/05 is a saturday, I need that cell to display 06/20/05, is that possible. Any help you can provide would be greatly appreciated. Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date
what happens if adding 2 would put it as the 1st or second day of the next
month (essentially month + 2)? -- Regards, Tom Ogilvy "David G" <David wrote in message ... I have a series of dates in column f, and the formula is DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)), but I need to check if this date is a weekend or weekday. Let us say 06/18/05 is a saturday, I need that cell to display 06/20/05, is that possible. Any help you can provide would be greatly appreciated. Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date
On Mon, 18 Apr 2005 07:15:02 -0700, "David G" <David
wrote: I have a series of dates in column f, and the formula is DATE(YEAR(F3),MONTH(F3)+1,DAY(F3)), but I need to check if this date is a weekend or weekday. Let us say 06/18/05 is a saturday, I need that cell to display 06/20/05, is that possible. Any help you can provide would be greatly appreciated. Thanks in advance Was there some problem with the responses in .misc? It would be helpful if you would respond there instead of multi posting. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
| date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
| Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Linear Mode
