4 & 2 Roster Calculations

[chad328]

Hi everyone,

This iy my very post after a long ime lurking & learning,
I own a small shutdown business for breakdowns on machinery & am trying to better time manage,
I would like to be able to save some time I spend in the office by speeding the process up of,
budgeting & quoting based on days job will take (B4) via the use of excel, any help would be much appreciated.

1 • On the spreadsheet attached I would like to be able to type into B4 however many days,
& have it reflected across from E5-6 onwards & remove/hide columns that are before the start date in B3

4N2Roster.xlsx

2 • I need to be able to A) Automatically highlight any columns that are weekends
• Count weekdays rostered on in AK7
• Count weekend days rostered on in AL7

Note: "1" on row 7 reflects how many people I require that day

As previously mentioned,
Any help in this matter would be much appreciated,
Regards,
Chad

[dubcap01]

Hi Chad,

forget that, re-read your post and still working on it

[dubcap01]

Hi Chad

This one requires the first day of the month typed in cell B1, but doesn't push out to 36 days.
It does allow for you to enter values (employees) up to 48 days in advance (and can be more but gets unworkable-ish)

Sat/Suns are highlighted, and changing the Start day in cell B3 changes the grid as you will see.

Hope this helps

Pete

[Punnam]

Hi,

Find the attached file.

Punnam

[chad328]

Pete,

Good to see a fellow Aussie shouting out with help mate,
Much appreciated, will take a bo peep asap I walk in the door.

Many thanks buddy,
Chad

[chad328]

Hi Punnam,

Many thanks, Like Pete's contribution to my problem I shall have a look within the hour when I get home from work,
Many thanks & kind regards,
Chad

[chad328]

Update:

What seems to have worked for me is the following which is a bit of both contributors, I thank you!

Conditional formatting to highlight weekend cells if contain "Sat","Sun"
=TEXT(BA9, "ddd")
=IF(ISBLANK($E$9),"",SUM(AZ9+1))

Thanks so much for giving me something to go on, It's awesome to learn!