Finding the week of date

E

ExcelUser09

I am working on a project that requires to me find out the date of the week
for all the calender days in a year. For example, 3/2/09 - 3/8/09 falls in
the week of 3/2/09 assuming that my week starts on Monday and ends on Sunday.

I've been browsing through all the formulas and have tried many combinations
of the IF and DATE functions, but without success. Appreciate any input!

My table will look like this --- I need to compute the "week of" date,
without having to enter this information manually.


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
 
M

Mike H

Hi,

assuming your first date in A2 put this in b2 and drag down

=IF(WEEKDAY(A2)=1,A2-6,A2-(WEEKDAY(A2)-2))

Mike
 
D

Dave Peterson

Check your other post, too.
I am working on a project that requires to me find out the date of the week
for all the calender days in a year. For example, 3/2/09 - 3/8/09 falls in
the week of 3/2/09 assuming that my week starts on Monday and ends on Sunday.

I've been browsing through all the formulas and have tried many combinations
of the IF and DATE functions, but without success. Appreciate any input!

My table will look like this --- I need to compute the "week of" date,
without having to enter this information manually.

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
Click to expand...
 

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

Finding Mondays 6
filter due this Week ,next week, > nextweek 2
Calculation Total Time With Dates/Times That Overlaps 4
Calculating Week of date 2
Automatically update a cell with a date based on anther cells date 2
How to get the Total count 6
Date between date range 1
vlookup or Match 6

Top