numbers numbers
New Member
- Joined
- Aug 18, 2008
- Messages
- 3
hello i am building a monthly schedule with calcs weekly and monthly, i am using the below calculation.
AL2 is the date 26/11/12 (always the 26th of the month)
cell calcs= a2 =TEXT(E3,"ddd") .... E3=DATE(YEAR(AL2),MONTH(AL2),DAY(AL2)) .... e4=TEXT(E3,"dd")
I need the sheet to show;
the week to start on a Monday (always) and a calculation to alert me if anyone works over 40 hours in the week (i know the calculation for the hours)
the month calculation runs from 26th to the 25th, whilst the sheet can show more days (if the 25th is a Monday for example then the sheet can run from 25 to 26th or beyond, but the monthly calculation will only calculate the days that are fall on 26th-25th (i think i know how to do that)
the bit i don't know how to do is getting the correct date to sit under the correct day, when the week must start on a Monday. i can send the sheet or a screen shot if any one can take a look, its easier to see than explain. thank you in advance.
AL2 is the date 26/11/12 (always the 26th of the month)
cell calcs= a2 =TEXT(E3,"ddd") .... E3=DATE(YEAR(AL2),MONTH(AL2),DAY(AL2)) .... e4=TEXT(E3,"dd")
I need the sheet to show;
the week to start on a Monday (always) and a calculation to alert me if anyone works over 40 hours in the week (i know the calculation for the hours)
the month calculation runs from 26th to the 25th, whilst the sheet can show more days (if the 25th is a Monday for example then the sheet can run from 25 to 26th or beyond, but the monthly calculation will only calculate the days that are fall on 26th-25th (i think i know how to do that)
the bit i don't know how to do is getting the correct date to sit under the correct day, when the week must start on a Monday. i can send the sheet or a screen shot if any one can take a look, its easier to see than explain. thank you in advance.
