180 Day Calendar

[coliervile]

I'm trying not to reinvent something that has been thought of already and tested. I'm specifically looking for a calendar that if I put a date in cell A1 (e.g. August 1, 2007) it will count backward 180 days, count includes the specific date- August 1, 2007, and highlight those days on a calendar. Has any one seen an excel file that does this or something similar?

Best regards,

Charlie

[Bob Phillips]

Here's a stab

[coliervile]

XLD- That a great idea. Is there a way to do the same thing but in a convention type of calendar format and still highlighting the 180 day period?

Best regards,

Charlie

[Bob Phillips]

What do you mean by a conventional type of calendar format?

[coliervile]

I guess a landscape layout. 3 months across the top and 4 rows down, days of the weeks across the top of each month, and the dates of the months.

Best regard,

Charlie

[coliervile]

Maybe something like this.

http://www.vertex42.com/ExcelTemplates/Images/monthly-calendar.gif

Best regard,

Charlie

[geekgirlau]

Nice use of conditional formatting XLD!

What about this variation?

[anandbohra]

geekgirlau & xld

both of u have shown awesome use of conditional formatting.

[geekgirlau]

I just built on XLD's example - I'm afraid there was only one set of brains in this team effort and I don't have them! :tongue:

[Bob Phillips]

Here's my offering

[coliervile]

xld- That's awesome it's exactly what I was looking for. thanks to geekgirlau and yourself for your assistance. I LOVE THIS WEBSITE!

Best regards,

Charlie

[Bob Phillips]

Good, so keep coming back.

[tqm1]

Dear Xld.

Thanks for good and interesting work.
Here I need something more.

How to apply following format on current date in respective cell
fontbold=.t.
backcolor=red

The current date is Range("G21") in your attachment workbook.

Please help

[Bob Phillips]

Funny you should ask that as I thought the same thing after I posted, and I changed the file but did not post it then.

Here it is.

[coliervile]

xld- Is there a way when a new year is typed is, like 2008, that all of the dates in each month auto update?

Best regards,

Charlie

[Bob Phillips]

Charlie,

If you change the input date, it already does that. So, say you use 5th May 2010, you will see it ripple across to reflect 2010.

Are you asking to be able to change the year in the top-left and the calendar to reflect that? If so, that would take VBA, and it works without VBA now. The best way if that is what you are suggesting is to have 3 cells, one for the year, one for the month, and 1 for the day, and drive it from there.

[coliervile]

xld- Thanks, I guess I should have tried that before even asking. Have a great day.

Best regards,

Charlie

[TrippyTom]

Hehe, this is pretty impressive and humiliating at the same time.
I did this same sort of thing a long time ago via VBA and now XLD comes along and casually provides a non-code solution. :bow:

[tqm1]

Dear Xld

What method should I adopt to show days as

Mon Tue Wed Thu Fri Sat Sun

Should I cut copy columns?

Please help

[tqm1]

Sorry for more questions

[sujittalukde]

Dear TrippyTom, can you provide the VBA?

[Bob Phillips]

Dear Xld

What method should I adopt to show days as

Mon Tue Wed Thu Fri Sat Sun

Should I cut copy columns?

Please help

It already does, at the top of each month.

[tqm1]

Dear Sir,

In your attached workbook SUN is first day but I want MON as first day of week.

[Bob Phillips]

Just change the days headings to start with the day you want, and see what happens <g>

[TrippyTom]

Sukittalukde,

It's always better to seek a non-code solution if you can (like XLD did). But if you really want to see the code I did, I would have to sterilize it a bit to remove any company-specific information first.