Excel Calendar without using VBA.

**Cyberpawz** · 03-26-2012, 02:38 PM

Ok, as we know today is march 26th 2012.

I am making a calendar, but what I want to do is if the month and year fields change, so do the dates inside the calendar. So in English March first of this year landed on a Thursday, what I want to do is if I type in 2012 in the year section, and March into the month, the correct days will show up underneath.

I found a script that will do what I want, but at the same time I can't verify if this will work because my work has locked down the calendar and time function on my OS, so basically I can't verify if this calendar will work past this month or not.

Can someone verify this for me?

**Dennis7849** · 03-26-2012, 03:26 PM

If this is work related, then get your work to allow you to do this. If it is not work related, then maybe you should not be doing it.

FYI: If you have a computer at home and Hi Speed internet, then you can do this from work using LogMeIn.

**Cyberpawz** · 03-26-2012, 03:33 PM

This is for work, they want me to do this, the administrator refuses to let loose the rules for anyone, including me to do my job correctly, this is a continuous form of tension between the administrator and the general end users. I've requested this to be released but the administrator refuses to do so. Probably because I know more about computers and networks than he does, but that is for another sto

As for your other bit, they have locked that down as well. Hence why I am asking. I'm not being lazy, I am asking because I either get paid to do this or I do it for free at home.

BTW, next time you post, be helpful, people here ask for help for a reason... btw, your website is down.

**icestationzbra** · 03-26-2012, 03:54 PM

@Cyberpawz:

take it easy on Dennis7849... also, we all feel we know more than the people actually doing their job, and i am sure others feel the same about us :-)... just saying...

by the way, i checked by changing the date on my office computer (they allow us to do that!!!), and the dates in your calendar updated just fine.

i have one comment / suggestion about your calendar. currently you have 5 rows for dates. you should get one more. here is why:

March 31st 2013 is a Sunday. it will not show up on your calendar because March 1st 2013 is a Saturday and it occupies the first row. March 30th 2013 is a Saturday, too, which occupies the last cell of the 5th row, hence pushing March 31st 2013 out in the wilderness.

also, if i may suggest, it is easier to download a nice little calendar template from within Excel 2007 (if you are using that), than making one of your own. just saying...

**JBeaucaire** · 03-26-2012, 03:58 PM

I've replaced your cells with drop downs at the top and simpler formulas. This calendar will adjust itself based on the month/year you select at the top.

**Cyberpawz** · 03-26-2012, 05:12 PM

Originally Posted by icestationzbra

@Cyberpawz:

take it easy on Dennis7849... also, we all feel we know more than the people actually doing their job, and i am sure others feel the same about us :-)... just saying...

by the way, i checked by changing the date on my office computer (they allow us to do that!!!), and the dates in your calendar updated just fine.

i have one comment / suggestion about your calendar. currently you have 5 rows for dates. you should get one more. here is why:

March 31st 2013 is a Sunday. it will not show up on your calendar because March 1st 2013 is a Saturday and it occupies the first row. March 30th 2013 is a Saturday, too, which occupies the last cell of the 5th row, hence pushing March 31st 2013 out in the wilderness.

also, if i may suggest, it is easier to download a nice little calendar template from within Excel 2007 (if you are using that), than making one of your own. just saying...

I did download an excel one, the problem was that it didn't do what I required so I decided on creating one from the ground up.

Thanks though for testing it out, it helps out knowing I'm on the right track. Although a 5th row, I have five rows... at least I do on mine, I thought I took the 5 week month into consideration...

As for me knowing more than the administrator, I hate to say it, but I do know more than he does. Everyone comes to me (someone that has been there less than a year) for tech support about their computers, networks issues, video editing, and database issues than someone who has been there a decade (the admin)... He is certified, I'm not... so you can see where the insecurity comes from.

When I ask for things his response is always no, even though I am justified in asking for things like the ability to adjust my date and time. I have to go to his boss to get things. Not the way I like doing it, but you do what you need to to make things work...

**JBeaucaire** · 03-26-2012, 05:16 PM

Or you make all your requests to him in writing CC'ing his boss and your coworkers on the "simple" requests.

Did you look at the file I posted in post #5?

**Cyberpawz** · 03-26-2012, 05:24 PM

I did thanks, I was trying to stay away from pulldown menus because it makes it look like it uses scripts. Hence my boss is one of those people if he doesn't understand it he doesn't want it. But his boss does so I keep going forward with it.

It's confusing, but realistically my boss is one of those people that is just outright insecure about his job.

**JBeaucaire** · 03-26-2012, 06:09 PM

I would disagree that anyone who sees a drop down thinks "scripts". But that's beside the point. You can remove those if you wish. I was just showing you a simpler and easier to read formula method. How the values get into the two boxes at the top is up to you.

If that takes care of your need, please click Thread Tools above your first post and mark this thread as SOLVED.

**Cyberpawz** · 03-26-2012, 06:19 PM

Originally Posted by JBeaucaire

I would disagree that anyone who sees a drop down thinks "scripts". But that's beside the point. You can remove those if you wish. I was just showing you a simpler and easier to read formula method. How the values get into the two boxes at the top is up to you.

If that takes care of your need, please click Thread Tools above your first post and mark this thread as SOLVED.

You may disagree with the thought process of my boss but that is what he thinks every time he sees excel open. I know this because I deal with it every time I have excel open, and have to explain to him why I have it open so I can do the things asked of me. It is annoying, wrong, and a headache attempting to explain to someone who doesn't wish to to learn how to make things work, and in an attempt to make my life a little easier... which it does ultimately once I get him off my back... but please trust me. My boss is a technology admin, who knows less about IT and management than my grandfather and my grandfather was programming OS/2 back in the 80s, and was a project director for MITRE during that time too.

Excel Calendar without using VBA.

LinkBack

Thread Tools

Rate This Thread

Display

Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Re: Excel Calendar without using VBA.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions