Round The weekday

[ShirleyT]

Dear expert,
I've got a question here :
How to I formulate in order to let the weekday to round into the same week
Friday ??

Example : if
A1= Aug 16, i want it to determine and become in
A2 =Aug 20,

Another example :

A1= Aug 18 , --> become in to
A2= Aug 20.


Friday is the start day.


Greatly appreicated for help.

Thanks.
ST

 

[Frank Kabel]

Hi
try:
=A1-WEEKDAY(A1-4,3)+7

 

[ShirleyT]

Dear Frank,
Thank you, however this work only partial right.
See, if

Aug 27 is a Friday. I want the outcome remain the same
that is if
A1= Aug27 then
A2= Aug 27

Saturday will be my beginning of the week. Friday is the end of the week.

Thank again for all the help.


Regards,
ST

 

[Frank Kabel]

Hi
try:
=A1-WEEKDAY(A1-4,3)+7*(WEEKDAY(A1,3)<>4)

 

[ShirleyT]

Ya...work perfect.
Thanks so much for your help.



Cheers.
Good day.

Regards,
ST

 

[Sandy Mann]

=A1-WEEKDAY(A1-4,3)+7*(WEEKDAY(A1,3)<>4)

or

=A1-(WEEKDAY(A1+1))+7


Regards

Sandy