ExcelBanter - pls help with conditional formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - pls help with conditional formula (https://www.excelbanter.com/excel-worksheet-functions/266753-pls-help-conditional-formula.html)

christina_d

pls help with conditional formula

1 Attachment(s)

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!

wickedchew

1 Attachment(s)

Quote:

Originally Posted by christina_d (Post 960555)

See attachment for a suggested template.

The colors will indicate Saturdays and Sundays.

lauratristin

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.

All times are GMT +1. The time now is 03:44 PM.