Hi

I have a calendar with everyday from "Sunday 1 Jan 2006" To "Sunday 31
Dec 2006". I need to make a macro that when it is run it will change
the year from 2006 To 2007.

Another thing is that I want saturday and sunday to be marked(say
green) But when the year changes the dates are push forward so now it
is sunday and monday that is marked. How to make it auto mark saturnday
and sunday again?

It would be nice to have it all in one macro

thanks

San

Take a look at http://xldynamic.com/source/xld.CF.html#calendar

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"San" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi
>
> I have a calendar with everyday from "Sunday 1 Jan 2006" To "Sunday 31
> Dec 2006". I need to make a macro that when it is run it will change
> the year from 2006 To 2007.
>
> Another thing is that I want saturday and sunday to be marked(say
> green) But when the year changes the dates are push forward so now it
> is sunday and monday that is marked. How to make it auto mark saturnday
> and sunday again?
>
> It would be nice to have it all in one macro
>
> thanks
>
> San
>

I can't seem to make the codes from the site to work! it just say wrong
formula even though I just copy paste.
I have my date format as (dddd-dd-mm) from A9:A39 and A44-A71 and so
on. Between A39 and A44 is just where I sum up some data.

pls help




Bob Phillips skrev:
> Take a look at http://xldynamic.com/source/xld.CF.html#calendar
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "San" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi
> >
> > I have a calendar with everyday from "Sunday 1 Jan 2006" To "Sunday 31
> > Dec 2006". I need to make a macro that when it is run it will change
> > the year from 2006 To 2007.
> >
> > Another thing is that I want saturday and sunday to be marked(say
> > green) But when the year changes the dates are push forward so now it
> > is sunday and monday that is marked. How to make it auto mark saturnday
> > and sunday again?
> >
> > It would be nice to have it all in one macro
> >
> > thanks
> >
> > San
> >

I need more info than that to work on as I know that the example does work.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"San" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I can't seem to make the codes from the site to work! it just say wrong
> formula even though I just copy paste.
> I have my date format as (dddd-dd-mm) from A9:A39 and A44-A71 and so
> on. Between A39 and A44 is just where I sum up some data.
>
> pls help
>
>
>
>
> Bob Phillips skrev:
> > Take a look at http://xldynamic.com/source/xld.CF.html#calendar
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "San" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hi
> > >
> > > I have a calendar with everyday from "Sunday 1 Jan 2006" To "Sunday 31
> > > Dec 2006". I need to make a macro that when it is run it will change
> > > the year from 2006 To 2007.
> > >
> > > Another thing is that I want saturday and sunday to be marked(say
> > > green) But when the year changes the dates are push forward so now it
> > > is sunday and monday that is marked. How to make it auto mark
saturnday
> > > and sunday again?
> > >
> > > It would be nice to have it all in one macro
> > >
> > > thanks
> > >
> > > San
> > >
>