LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Calculation Time with multiple sheet and linked workboo John B Excel Discussion (Misc queries) 0 April 7th 07 09:26 AM
incerting calender in a spread sheet cell Jo Excel Worksheet Functions 0 May 18th 06 12:21 AM
Calender Object problem in Excel 2000 and 2003 Suketu Excel Discussion (Misc queries) 0 April 20th 06 08:29 PM
calender drop down in an exel sheet sinbad Excel Worksheet Functions 2 November 17th 05 12:05 PM
how do I print 12 month calender in one sheet kumaratfl Excel Discussion (Misc queries) 1 August 19th 05 04:27 PM


All times are GMT +1. The time now is 05:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"