| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extra help on Nth Day of month
I have inputted the following =DATE(YEAR(E2),MONTH(E2),3)
E2 has the date as 1st of the current month Which gives me the 3rd day of the month I need to add the followin extra rules 1) If 3rd is Wednesday change date to Thursday 4th 2) If 3rd is Sat or Sun go to Next Monday date |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Date, Include dates from rest of month and all of next month | Excel Programming | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Extra month shown in date count | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
