check previous weekday date based on a specific dates

hi,

specific dates of 7,14, 22 and the last day of the month

rules for the above dates
1. if the specific date is a Friday-Saturday-Sunday the previous weekday date will be Thursday
2. if the specific date is a Thursday previous weekday date will be Wednesday
3. if the specific date is a Wednesday previous weekday date will be Tuesday
4. if the specific date is a Tuesday previous weekday date will be Monday
5. if the specific date is a Monday previous weekday date will be Friday

example for April 2018

7 is on Saturday so display on A1 "The previous weekday is 5-Thursday"
then the actual date on B1 "04/05/18"

14 is on Saturday so display on A2 "The previous weekday is 12-Thursday"
then the actual date on B2 "04/12/18"

22 is on Sunday so display on A3 "The previous weekday is 19-Thursday"
then the actual date on B3 "04/19/18"

30(last day of Apr 2018) is on Monday so display on A4 "The previous weekday is 27-Friday"
then the actual date on B4 "04/27/18"

Originally Posted by k1dr0ck

specific dates of 7,14, 22 and the last day of the month

Please Login or Register  to view this content.

hi,

thanks for the replies

@aligw
i was thinking of also posting this in the formula forums
but i think its not allowed to post same question in different forums

@jindon
i moved the dates column B
how do i show the string "The previous weekday is 5-Thursday" on A1
and also for the other 3 dates
im guessing it will be on the line with the blue font color below

Please Login or Register  to view this content.

Originally Posted by k1dr0ck

@jindon
i moved the dates column B
how do i show the string "The previous weekday is 5-Thursday" on A1
and also for the other 3 dates

What do you mean?
The code will put the "previous weekday" for 7, 17, 22 and end of month of current month.

If it is not what you want, upload a workbook with before/after.

hi,

attached file

i see, thanks for the tip

Originally Posted by AliGW

It isn't, but you could have steted "Formula or VBA" in your thread title.

Is this what you want?

Please Login or Register  to view this content.

yup, thats it!, thanks!