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

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