 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006Question about having the date autofill for schedule sheets
I am currently trying to have the date auto fill for 6 days of the week on a spreadsheet with 5 sheets on it. Our work week is Mon - Sat and I was wondering if there is a formula that I can use that when I entered the date for Monday July 31st it would auto fill in the correct date for the rest of the sheets. Thank you ahead of time! Let's assume your entered date of July 31 is in cell A1 of Sheet1. In cell B1, you could enter: =DATE(YEAR(A1),MONTH(A1),DAY(A1)+1) Copy this formula across to cell F1. You've now got your first 6 days displayed across the top of Sheet1. Now, in cell A1 of Sheet2 enter: =DATE(YEAR('Sheet1'!A1),MONTH('Sheet1'!A1),DAY('Sheet1'!A1)+7) Copy this formula across to cell F1. You've not got your second week of 6 days displayed across the top of Sheet2. Repeat this for your other sheets. You could also copy the formula down rows instead of across columns if preferred. HTH, Elkar > I am currently trying to have the date auto fill for 6 days of the week on a > spreadsheet with 5 sheets on it. Our work week is Mon - Sat and I was [quoted text clipped - 3 lines] > > Thank you ahead of time! The formula for sheet 2 is giving me an error and is asking me to update the excel file and when I select it, it adds [WEEK1] to the forumla > Let's assume your entered date of July 31 is in cell A1 of Sheet1. In cell > B1, you could enter: [quoted text clipped - 24 lines] > > > > Thank you ahead of time! Sorry I am using Week 1 for the sheet names not Sheet 1 which I did change in the formulas > The formula for sheet 2 is giving me an error and is asking me to update the > excel file and when I select it, it adds [WEEK1] to the forumla [quoted text clipped - 27 lines] > > > > > > Thank you ahead of time! I only used Sheet1 and Sheet2 as example names. If the names of your sheets are different, then use your names. So, if your first sheet is called WEEK1 then use this: =DATE(YEAR('WEEK1'!A1),MONTH('WEEK1'!A1),DAY('WEEK1'!A1)+7) HTH, Elkar > The formula for sheet 2 is giving me an error and is asking me to update the > excel file and when I select it, it adds [WEEK1] to the forumla [quoted text clipped - 27 lines] > > > > > > Thank you ahead of time! Finally the sanity has ended! Thank you so much!!! > I only used Sheet1 and Sheet2 as example names. If the names of your sheets > are different, then use your names. So, if your first sheet is called WEEK1 [quoted text clipped - 36 lines] > > > > > > > > Thank you ahead of time! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.