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