G GEM Jan 19, 2009 #1 Is there a function where I can set a cell to give me the corresponding week number of the year for any given date??
Is there a function where I can set a cell to give me the corresponding week number of the year for any given date??
R Ron de Bruin Jan 19, 2009 #2 Hi GEM There are different week number systems Start here http://www.rondebruin.nl/weeknumber.htm Or on MSDN http://msdn.microsoft.com/en-us/library/bb277364.aspx
Hi GEM There are different week number systems Start here http://www.rondebruin.nl/weeknumber.htm Or on MSDN http://msdn.microsoft.com/en-us/library/bb277364.aspx
B Bernard Liengme Jan 19, 2009 #3 Have a look in Help at WEEKNUM If you not resident in USA, Google with something like "Excel WEEKNUM Europe" to see how to do a workaround for Europe best wishes
Have a look in Help at WEEKNUM If you not resident in USA, Google with something like "Excel WEEKNUM Europe" to see how to do a workaround for Europe best wishes
