| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extra help on Nth Day of month
Hi,
Am Thu, 4 Oct 2012 10:12:31 +0000 schrieb RSJ001: 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 try: =E2+2+CHOOSE(WEEKDAY(E2+2),1,,,1,,,2) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| 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) | |||
Linear Mode
