hi
i'm not sure i completely understand what your are trying to do with such
sketchy information but if this will help, see these sites. they have already
worked up some timesheets that might help.
http://j-walk.com/ss/excel/files/timesht.htm
http://www.cpearson.com/excel/overtime.htm
at the bottom of chip's site are a number of links to other timesheet
related stuff.

regards
FSt1

Sorry I have been unclear. What I need is a formula (or look up) which
automatically returns that May 1 2008 was a Thursday and May 31 will be a
Saturday and assigns the correct days and dates to each other for the rest
of the month. Similarly that knows June 2008 is a 30 day month beginning on
a Sunday and ending on a Monday etc and similarly matches days of the week
to dates and thus forward for all months, correctly taking into account leap
years. The date time function in windows does all this very well working
from the same information i.e.. month and year but can I replicate it in
Excel?

Knowing that a date is a Saturday or Sunday for example is important to my
timesheet because there are higher payrates for weekend work. I want my
monthly time sheet to begin correctly on the right day of the week as the
first and to end appropriately on the last day of the month, with the
correct number of days in the month.

Can it be done?

Peter>