In summary I have dates in a cell if it is Monday, I require the next tuesday or next day
I am using the following formula to create the dates
This example I want the 8th Day of the month if the 8th is Monday update date to 9th Tuesday
=DATE(YEAR(A1),MONTH(A1),8)
Bookmarks