How to generate dates

[Maddy1234]

Hi all,

I have a rather peculiar problem. I have created a simple OT tracker.

[/IMG]

I want help in generating the data for the last two columns. Dates Worked Normal OT should tell which are the days a certain employee stayed back for OT on a weekday. So for example for Bob, this column will display "02/01/2018, 03/01/2018, 04/01/2018, 05/01/2018, 10/01/2018, 12/01/2018". For Bob, Dates Worked Double OT will display "06/01/2018, 07/01/2018, 13/01/2018".

Double OT is paid for OT covered in weekends.

I would like a formula where the last two columns are automatically updated when the data for Week3 and Week4 are added.

Your help is much appreciated. Thank you.

Maddy

 

[wideboydixon]

Hey,

I think you'd be better served to start a new topic as it's now a different question and you'll get more interest and feedback that way.

WBD

 

[Maddy1234]

Cheers mate. Will do that.

Hey,

I think you'd be better served to start a new topic as it's now a different question and you'll get more interest and feedback that way.

WBD