View Single Post
 
Old 03-25-2014, 10:04 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Take a look at what I have attached.

To test, enter the date you want (e.g. today's date) into the highlighted cell.

The table beneath give the number of weeks back from the test date (1 -65...so goes back over a year), the start date, the end date and the number I think you're looking for, the week number.

There are probably more elegant solutions.
Attached Files
File Type: xlsx YounesB3.xlsx (12.4 KB, 18 views)
Reply With Quote