View Single Post
  #1   Report Post  
RSJ001 RSJ001 is offline
Junior Member
 
Posts: 1
Post 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