Days of the Month

E

ExcelDummie

Im doing a timesheet and i really want to throw my pc out of the window now

i need to get a to take the total hours worked a week from hours contracted but the weeks arent always complete at the beginning or end of the month so contracted hrs change and the cell where the formula should be worked out changes too as the dates are filled in automatically days move in the rows but the column stays the same. i have been using if statements to recognise whether it is a "fri" but dunno how to change it for the first and last week !!!
 
J

jeff

Hey,

Can you give an example of your layout so we can better
understand the problem?

jeff
-----Original Message-----
Im doing a timesheet and i really want to throw my pc out of the window now

i need to get a to take the total hours worked a week
Click to expand...
from hours contracted but the weeks arent always complete
at the beginning or end of the month so contracted hrs
change and the cell where the formula should be worked
out changes too as the dates are filled in automatically
days move in the rows but the column stays the same. i
have been using if statements to recognise whether it is
a "fri" but dunno how to change it for the first and last
week !!!
 
Top