Weeknum & Year

[AnitaML]

Hi

I asked this question once before about a year ago, but I can't remember
what the solution was. I want to be able to display the week number and the
year together, as some of my dates are now beginning to run in 2006. Can
someone advise how I do this?

Thanks

Anita

[Ian]

=WEEKNUM(A15)&"/"&YEAR(A15) where your date is in A15

--
Ian
--
"AnitaML" <[email protected]> wrote in message
news:[email protected]...
>
> Hi
>
> I asked this question once before about a year ago, but I can't remember
> what the solution was. I want to be able to display the week number and
> the
> year together, as some of my dates are now beginning to run in 2006. Can
> someone advise how I do this?
>
> Thanks
>
> Anita

[AnitaML]

Thanks very much Ian - that did the job perfectly.

Anita

"Ian" wrote:

> =WEEKNUM(A15)&"/"&YEAR(A15) where your date is in A15
>
> --
> Ian
> --
> "AnitaML" <[email protected]> wrote in message
> news:[email protected]...
> >
> > Hi
> >
> > I asked this question once before about a year ago, but I can't remember
> > what the solution was. I want to be able to display the week number and
> > the
> > year together, as some of my dates are now beginning to run in 2006. Can
> > someone advise how I do this?
> >
> > Thanks
> >
> > Anita
>
>
>