hey all, I'm new here... been searching far and wide for what seems like should be simple. I am a glass blower- not a programmer- but I'm working on learning vba at the moment working on a basic calendar/ to do type application in Excel 2003... on windows xp... and I'm stuck.

So I've found a number of ways to do calendars- but I'm making one that is linear i.e. just goes left to right... any suggestions on that would be appreciated. I did make one but I'm sure there is a better way then I did it.

The main thing I need- why I'm posting- is simply this: I need to reference the year in a date in a cell.... that's all.. just look at the date and say what year it is so that I can then color the different years differently. This isn't that hard is it? I've been able to find different things in code that are close but they're essentially either referencing ONE date (i.e. a start date) or they system date... how do I tell the code to look at any random cell with a date in it and capture the year so as to use that as a reference further??

Thanks for any help!