Extra help on Nth Day of month

R

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 dat
 
C

Claus Busch

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
Click to expand...

try:
=E2+2+CHOOSE(WEEKDAY(E2+2),1,,,1,,,2)


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilling dates 3
Search closest day in the past from today 2
Workbook question... 1
Sum of Numbers of a Rolling 6 month Period range 0
counting weeks in current month. 1
create a month column from date column 5
date into current and previous quarters 3
Conditional Formatting of rows on a calendar 1

Top