View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Balcombe Peter Balcombe is offline
external usenet poster
 
Posts: 2
Default Calender function - time sheet - excel 2003/7

(Newcomer please be gentle!)

I am trying to set up a monthly time sheet spreadsheet for an organisation
that has staff working 7x24.

Ideally I should like the spreadsheet to automatically assign the date and
day of the week working from user input data (from drop down lists for
month, and year) so that for the current month (May 2008) the information
would appear as follows:-

Day Date

Thursday 1
Friday 2

and so on to

Friday 30
Saturday 31


Obviously the spreadsheet would need in some way to work off Julian calender
data.

Is this possible or do I ask too much?


Peter