Days of the Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !!!
 
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 !!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export data from the same cell from multiple spreadsheets into a n 1
Last day of the Month??? 1
cumulative total 1
formula or calculation for adding negative hour and positive hours 1
Formulas 6
changing dates into months 1
Excel Message box with days of month & date. 1
Help, How can I deduct time for a timesheet? 7

Back
Top