close
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)
quot;Edquot; gt; wrote in message
...
gt; Hello, does anybody know a way to have a date writtenin a cell and have
gt; another cell tell to which week of the year it belongs?
gt;
gt; thanks,
gt;
Thank you!
全站熱搜
留言列表
