I have a date in cell M3, I need cell N3 to return the following Friday date.
Here is the formula I used:
=M3-WEEKDAY(M3,3)+IF(AND(WEEKDAY(M3,3)>=5,WEEKDAY(M3,2)<=5),9,11)
HOWEVER, I if the date in cell M3 is on a Monday Tuesday or Wednesday, I need the Friday date to be of that week.
If the date in cell M3 is on a Thursday or Friday, I need the Friday date to be that of the following week.
Examples:
M3 = 7/26/10 N3 needs to return 7/30/10
M3 = 7/29/10 N3 needs to return 8/6/10
Patiently waiting your excel mastery assistance.
Thank you.
Bookmarks