Round The weekday

S

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
 
S

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
 
Top