 |
 | 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 / March 2008Can I set up an excel doc to auto fill 27 days in next cell?
I am trying to create a spreadsheet where I can enter a date and have a date 27 days from that date pop into the cell next to it. I need to do this for 7 months. I don't even know if it's possible. For example, if I put the date 10/01/2008 into a cell, I want the spreadsheet to calculate 27 days and put that date into the next cell (10/28/2008). I want it to do that for 7 cells. =a2+27 assuming de 10/01/2008 is in A2 hth  Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > I am trying to create a spreadsheet where I can enter a date and have a date > 27 days from that date pop into the cell next to it. I need to do this for 7 [quoted text clipped - 3 lines] > spreadsheet to calculate 27 days and put that date into the next cell > (10/28/2008). I want it to do that for 7 cells. Say date 10/01/2008 is in A2 then in B2 enter =A2+27 Make sure B2 is formatted the same as A2 If the 27 days is variable put the variable number of days in A1 then in B2 enter =A2+A1 Copy down as necessary > I am trying to create a spreadsheet where I can enter a date and have a date > 27 days from that date pop into the cell next to it. I need to do this for 7 [quoted text clipped - 3 lines] > spreadsheet to calculate 27 days and put that date into the next cell > (10/28/2008). I want it to do that for 7 cells. Thank you, that worked well. Is there a way to have columns automatically set up to do this? I put 27 in A2, then 10/01/08 in b2, then i put a2+b2, etc down the row. Is there a way to make the columns just know what I want them to do? I know I'm asking a lot. > Say date 10/01/2008 is in A2 then in B2 enter =A2+27 > Make sure B2 is formatted the same as A2 [quoted text clipped - 9 lines] > > spreadsheet to calculate 27 days and put that date into the next cell > > (10/28/2008). I want it to do that for 7 cells. Possibly What exactly do you want the columns to do? > Thank you, that worked well. Is there a way to have columns automatically > set up to do this? I put 27 in A2, then 10/01/08 in b2, then i put a2+b2, [quoted text clipped - 14 lines] > > > spreadsheet to calculate 27 days and put that date into the next cell > > > (10/28/2008). I want it to do that for 7 cells. My spreadsheet has columns a-l used for client info. Each row is a different client. k-z are alternating columns of the months and times. Each client is seen monthly from october to may. What I want is to be able to enter their first appointment date in column k, and have the spreadsheet auto-populate the dates into the rest of the columns. I'm always sorting the sheet to find out who's being seen on which days, and it takes a great deal of time to pull out a calander and figure it out each time. > Possibly > What exactly do you want the columns to do? [quoted text clipped - 17 lines] > > > > spreadsheet to calculate 27 days and put that date into the next cell > > > > (10/28/2008). I want it to do that for 7 cells. OK I think I can see what you're about. More more questions tho'. You mention a cycle of 27 days - how are you dealing with weekends within the 27 days? ie if the 27th day after the last appointment falls in a weekend do you reschedule to the following Monday - or what? Is the time of the appointment the same for each consecutive date? How are you sorting the sheet to determine the next appointment? > My spreadsheet has columns a-l used for client info. Each row is a different > client. k-z are alternating columns of the months and times. Each client is [quoted text clipped - 25 lines] > > > > > spreadsheet to calculate 27 days and put that date into the next cell > > > > > (10/28/2008). I want it to do that for 7 cells. Patients are seen on week-ends, so it's 27 days whenever that happens to fall. The time of the appointment changes, which is why i usually put that in a different cell (I would be willing to not havethe time there at all if I have to). I sort the sheet by date in the month I'm looking at. > OK I think I can see what you're about. More more questions tho'. > You mention a cycle of 27 days - how are you dealing with weekends within [quoted text clipped - 33 lines] > > > > > > spreadsheet to calculate 27 days and put that date into the next cell > > > > > > (10/28/2008). I want it to do that for 7 cells. You can maintain your current layout inc. the appointment time column. However for ease of operation at a later date (if the 27 days alter) I suggest inserting a column before the column K (Oct). Then enter 27 in the new column K for each client row. Assuming your first client details populate row 3, in column N (Nov) enter =if(L3="","",$K3+L3). Copy and paste across to each Month column (missing the appointment time column) i.e. Dec to May. Now highlight cells N3:Z3 and drag down as far as you need. Enter a date into L3 and dates, 27 days apart, should automatically fill in each of the month columns. Just change the 27 to any other number to change the appointment frequency. Because there is a common period of 27 days between each date - sorting on one month will sort ALL months. One problem I see; because the period is only 27 days there will be ocassions when the month shown in the cell will not be the same as the column heading! Enter the appointment times as normal. I hope I haven't gone into too much detail. Come back if you need further help. > Patients are seen on week-ends, so it's 27 days whenever that happens to > fall. The time of the appointment changes, which is why i usually put that [quoted text clipped - 38 lines] > > > > > > > spreadsheet to calculate 27 days and put that date into the next cell > > > > > > > (10/28/2008). I want it to do that for 7 cells. |
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
|
©2008 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.