Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
Good Afternoon! I am working on a spreadsheet calendar for my work and I am
having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
Hi,
You've got me stumped here. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) If A4 is Sunday & G4 is Friday what goes in the intervening 5 cells and in what order? Mike "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
Sorry about that, let me explain a little better.
A1 is where the user will enter the month and year. A4 thru G4 are the days of the week. (A4 Sunday, B4 Monday) and this is where I would like the dates to show up when the user inputs the month and year in A1. So if the user puts August 2008 in A1, I would like A4 to show July 27th, B4 show July 28, and continue through the spreadsheet like a calendar. "Mike H" wrote: Hi, You've got me stumped here. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) If A4 is Sunday & G4 is Friday what goes in the intervening 5 cells and in what order? Mike "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
A1 is August 2008
A4 needs to be July 27, B4 needs to be July 28, etc to G4 needs to be August 2 A12 needs to be August 3 etc to G12 needs to be August 9 A20 needs to be August 10 etc to G12 needs to be August 16 A28 needs to be August 17 etc to G12 needs to be August 23 and I would like it to change as the user puts in different months and years. Hope that helps with what i am trying to do... "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
There are a number of pre-built calendar templates on the Office website.
Perhaps one of them will suit your purposes, or at least offer some formulas you can steal, er, borrow. "VegasBurger" wrote: A1 is August 2008 A4 needs to be July 27, B4 needs to be July 28, etc to G4 needs to be August 2 A12 needs to be August 3 etc to G12 needs to be August 9 A20 needs to be August 10 etc to G12 needs to be August 16 A28 needs to be August 17 etc to G12 needs to be August 23 and I would like it to change as the user puts in different months and years. Hope that helps with what i am trying to do... "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
The Office Templates are at:
http://office.microsoft.com/en-us/te...CL100632981033 "VegasBurger" wrote: A1 is August 2008 A4 needs to be July 27, B4 needs to be July 28, etc to G4 needs to be August 2 A12 needs to be August 3 etc to G12 needs to be August 9 A20 needs to be August 10 etc to G12 needs to be August 16 A28 needs to be August 17 etc to G12 needs to be August 23 and I would like it to change as the user puts in different months and years. Hope that helps with what i am trying to do... "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
Well, the only cell that really 'matters' is A4. Since B4=A4+1, C4=B4+1, etc.
A4: =$A$1-WEEKDAY($A$1)+1 -- John C "VegasBurger" wrote: A1 is August 2008 A4 needs to be July 27, B4 needs to be July 28, etc to G4 needs to be August 2 A12 needs to be August 3 etc to G12 needs to be August 9 A20 needs to be August 10 etc to G12 needs to be August 16 A28 needs to be August 17 etc to G12 needs to be August 23 and I would like it to change as the user puts in different months and years. Hope that helps with what i am trying to do... "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
My advice, just say no to dating spreadsheets.
-- John C "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
why reinvent the wheel. Microsoft has a good calnedar here and there are
dozens of others that can be Googled http://support.microsoft.com/kb/150774 Mike "VegasBurger" wrote: Sorry about that, let me explain a little better. A1 is where the user will enter the month and year. A4 thru G4 are the days of the week. (A4 Sunday, B4 Monday) and this is where I would like the dates to show up when the user inputs the month and year in A1. So if the user puts August 2008 in A1, I would like A4 to show July 27th, B4 show July 28, and continue through the spreadsheet like a calendar. "Mike H" wrote: Hi, You've got me stumped here. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) If A4 is Sunday & G4 is Friday what goes in the intervening 5 cells and in what order? Mike "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
Now for the evil twist. and it might be too much but is there a formula to
show a holiday in the month? "John C" wrote: Well, the only cell that really 'matters' is A4. Since B4=A4+1, C4=B4+1, etc. A4: =$A$1-WEEKDAY($A$1)+1 -- John C "VegasBurger" wrote: A1 is August 2008 A4 needs to be July 27, B4 needs to be July 28, etc to G4 needs to be August 2 A12 needs to be August 3 etc to G12 needs to be August 9 A20 needs to be August 10 etc to G12 needs to be August 16 A28 needs to be August 17 etc to G12 needs to be August 23 and I would like it to change as the user puts in different months and years. Hope that helps with what i am trying to do... "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
Come on this is fun! (insert evil laugh)
"John C" wrote: My advice, just say no to dating spreadsheets. -- John C "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Dating Issue
Sure, depends on how you want to show them. You just need to have a 'list'
somewhere of all the holidays. I usually have a separate tab, such as tables, and you would have to manually enter all the holidays on the list, and just keep adding as years go by. Then, for example, in the conditional formatting for A4, change the drop down to Formula Is: and the formula to: =COUNTIF(Holidays,A4)=1 and then format how you would like. This would take a bit of manual preparation, as depending on how many cells you have for each day, you would want to ensure, for example, cells A5:A10 all have the same =COUNTIF(Holidays,A4)=1. You want to ensure they ALL reference cell A4, and then can copy and paste the conditional formatting in other cells as needed. -- John C "VegasBurger" wrote: Now for the evil twist. and it might be too much but is there a formula to show a holiday in the month? "John C" wrote: Well, the only cell that really 'matters' is A4. Since B4=A4+1, C4=B4+1, etc. A4: =$A$1-WEEKDAY($A$1)+1 -- John C "VegasBurger" wrote: A1 is August 2008 A4 needs to be July 27, B4 needs to be July 28, etc to G4 needs to be August 2 A12 needs to be August 3 etc to G12 needs to be August 9 A20 needs to be August 10 etc to G12 needs to be August 16 A28 needs to be August 17 etc to G12 needs to be August 23 and I would like it to change as the user puts in different months and years. Hope that helps with what i am trying to do... "VegasBurger" wrote: Good Afternoon! I am working on a spreadsheet calendar for my work and I am having a issue with the date reflecting the month the user puts into the sheet. A1 is where the user will type in the date such as august 2008. I have columns A thru G for the days in the week but I would like the have the date autofill the boxes on the calendar. So A4 is Sunday G4 is Friday and then A12 is Sunday G12 is Friday (2nd week) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dating a file. | Excel Discussion (Misc queries) | |||
How do I change from american dating to uk dating? | Excel Worksheet Functions | |||
How to update dating? | New Users to Excel | |||
dating problems! | Excel Worksheet Functions | |||
Progressive Dating of Columns | New Users to Excel |