Calculating Week of 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tally the figures acquired from the same date 3
Counting Unique Days based on multiple criteria 5
Finding the week of date 4
MTD Rating 1
WCG Stats Tuesday 22 August 2023 3
WCG Stats Monday 17 July 2023 2
WCG Stats Saturday 15 July 2023 3
WCG Stats Sunday 20 August 2023 3

Top