Weekending Forumula

[Jerome_RA]

Hi Excel Guru's.

I need help on a Weekending formula for Saturday to Friday. So if the Date falls from April 20 -26, 2019, result will be WE 04.26.19. and so on.

Date Data will be on column A while Result will be on Column B.

Thank you.

 

[Joe4]

For a date in cell A1, try:

="WE " & TEXT(A1+7-WEEKDAY(A1,16),"mm.dd.yyyy")

 

[Fluff]

How about
=A2+7-WEEKDAY(A2,16)

 

[Jerome_RA]

Working perfectly. Thank you so much Joe4 and Fluff! You guys are the best!

 

[Joe4]

You are welcome.
Glad we were able to help.