Hello,

I am new with this forum and i hope that someone can help me with my current problem.
I need a formula that In colum CS4 CS5, etc (pls see attached excel), if the employee worked on sundays, to bring the date of the sunday in which he worked automatically.

Thank you so much!

See attachment for a suggested template.

The colors will indicate Saturdays and Sundays.

This attracted file is very nice and best to share here. It is very much needed as well as very best file. I uploaded it, it is very good as well as very easy to work with it.