Calculating Week of date

  • Thread starter Thread starter ExcelUser09
  • Start date Start date
E

ExcelUser09

Hello - I need to find a way to obtain the date of the week (assuming day 1
of the week is Monday), so I don't have to fill out the data manually. My
table should look like this --

Date Week of
11/17/2008 11/17/2008
11/18/2008 11/17/2008
11/19/2008 11/17/2008
11/20/2008 11/17/2008
11/21/2008 11/17/2008
11/22/2008 11/17/2008
11/23/2008 11/17/2008
11/24/2008 11/24/2008
11/25/2008 11/24/2008
11/26/2008 11/24/2008
11/27/2008 11/24/2008
11/28/2008 11/24/2008
11/29/2008 11/24/2008
11/30/2008 11/24/2008

I will provide the date, but need a formula so it will calculate the
corresponding week of that particular date.
 
Back
Top