excel training onsite - Date functions

Hi Vijay. This depends on what year you're talking about as the start date of, say week 1, in 2007 is going to be different to that of 2006. Plus Excel makes a distinction between starting a week on a Sunday or a Monday. However, the discussion here:

http://www.developersdex.com/vb/message.asp?p=2677& ;r=5955664

...should give you a few pointers, particularly the VBA and worksheet function examples.

Hope this helps,

Anthony