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: 84
Default Sheets dates,weeks and Months. How do I

Hi all,

I have a workbook with 31 sheets for each day of the month, I also
have 5 sheets for weekly data.

How do I for every month put a date on a menu sheet so that the start
of the month (day) date is put into the right sheet and have the
weekly data sheets match up.?

Example in Australia March 1st starts on Thursday and I need Friday
Saturday Sunday to appear on the 1st weekly sheet.. and so on.


thanks for any ideas..
Stephen

 
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
My discovery on adding months and days to a date! Epinn Excel Worksheet Functions 8 October 9th 06 10:27 PM
CAn any one solve this problem of days months and years.its urgent plzzzzzzzzzzzz naughtyboy Excel Discussion (Misc queries) 3 August 19th 06 05:45 PM
months between 2 dates!!! speary Excel Discussion (Misc queries) 1 August 19th 05 03:22 PM
Why "datedif" function results sometimes negative numbers? Ambrosiy Excel Worksheet Functions 1 July 8th 05 11:29 AM
how do i name the sheets after the months craig Excel Worksheet Functions 1 February 2nd 05 03:01 AM


All times are GMT +1. The time now is 09:59 PM.

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"