G Guest Jan 5, 2005 #1 I want to to format one Date like 2005-01-06 to which Weeknumber it is. How do i do that?
F Frank Kabel Jan 5, 2005 #2 Hi can't be done with a format. But you may use a helper column to show the weeknumber of this date. See: http://www.rondebruin.nl/weeknumber.htm and http://www.cpearson.com/excel/weeknum.htm
Hi can't be done with a format. But you may use a helper column to show the weeknumber of this date. See: http://www.rondebruin.nl/weeknumber.htm and http://www.cpearson.com/excel/weeknum.htm
