Moving data as date changes

[mookie2600]

Hello!

I have a tracker to calculate manufacturing lead time that looks ahead 6 weeks. Cell E1 is todays date (referencing off A1), and the rest of row 1 is E1+1 etc, all the way out to cell AT1. I would like to have the daily work hours shift left following the dates in row 1, and have cells AT3,4,5 automatically fill in new work hours based on B3,4,5 which shows the typical schedule for these three workers.

I have tried some formulas with no luck. Is there a better way? Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
How about in E3 copied down & across

=IF(WEEKDAY(E$1,2)<6,$B3,0)

 

[Fluff]

Another option as you are on 365 in E3 copied down only

=IF(WEEKDAY(E$1:AT$1,2)<6,$B3,0)

 

[mookie2600]

Hi & welcome to MrExcel.
How about in E3 copied down & across

=IF(WEEKDAY(E$1,2)<6,$B3,0)

Thank you. Long time reader, and have found many solutions on these forums.

This does exactly what I need it to do. I will just have to figure out how to add in sick/vacation days.

Thanks again!

 

[Fluff]

You're welcome & thanks for the feedback.