Weeknum & Year
 

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

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

--
Ian
--
"AnitaML" wrote in message
...

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

Thanks very much Ian - that did the job perfectly.

Anita

"Ian" wrote:

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

--
Ian
--
"AnitaML" wrote in message
...

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