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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)