Hello, does anybody know a way to have a date writtenin a cell and have
another cell tell to which week of the year it belongs?

thanks,

In the other cell, add

=WEEKNUM(A1)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Ed" wrote in message
...
Hello, does anybody know a way to have a date writtenin a cell and have
another cell tell to which week of the year it belongs?

thanks,

Thank you!