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)