PDA

View Full Version : 180 Day Calendar



coliervile
07-19-2007, 10:41 AM
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

xld
07-19-2007, 02:46 PM
Here's a stab

coliervile
07-19-2007, 04:09 PM
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

xld
07-19-2007, 04:10 PM
What do you mean by a conventional type of calendar format?

coliervile
07-19-2007, 05:37 PM
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
07-19-2007, 05:38 PM
Maybe something like this.

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

Best regard,

Charlie

geekgirlau
07-19-2007, 06:11 PM
Nice use of conditional formatting XLD!

What about this variation?

anandbohra
07-19-2007, 09:48 PM
geekgirlau & xld

both of u have shown awesome use of conditional formatting.

geekgirlau
07-19-2007, 10:30 PM
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:

xld
07-20-2007, 02:06 AM
Here's my offering

coliervile
07-20-2007, 04:25 AM
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

xld
07-20-2007, 05:19 AM
Good, so keep coming back.

tqm1
07-20-2007, 06:32 AM
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

xld
07-20-2007, 07:11 AM
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
07-20-2007, 11:30 AM
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

xld
07-20-2007, 11:40 AM
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
07-20-2007, 11:51 AM
xld- Thanks, I guess I should have tried that before even asking. Have a great day.

Best regards,

Charlie

TrippyTom
07-20-2007, 12:02 PM
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
07-20-2007, 07:02 PM
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
07-20-2007, 07:22 PM
Sorry for more questions

sujittalukde
07-20-2007, 10:20 PM
Dear TrippyTom, can you provide the VBA?

xld
07-21-2007, 01:37 AM
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
07-21-2007, 03:05 AM
Dear Sir,

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

xld
07-21-2007, 03:49 AM
Just change the days headings to start with the day you want, and see what happens <g>

TrippyTom
07-23-2007, 09:57 AM
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.