Finding the Monday date based on a different date in same week

G

Guest

I have a series of dates (monday through friday) in several weeks and months
throughout the year. I would like to create a corresponding column that
indicates what the Monday date during the week of the original date.

If A1 is original date of 4/14/2006, how can I extract the Monday date of
4/10/2006 into cell B1?
 
G

Guest

Try this:

For a date in A1

B1: =A1+2-WEEKDAY(A1)
That formula returns the Monday date of the same week as the date in A1


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
B

Bob Phillips

=A1-(WEEKDAY(A1)-2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

Guest

Excellent! Thank you very much.


Ron Coderre said:
Try this:

For a date in A1

B1: =A1+2-WEEKDAY(A1)
That formula returns the Monday date of the same week as the date in A1


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
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

Change colour based on date 6
Deriving an earlier date based on a later date 7
calculating a date using the day of the week as a starting point? 2
Calculate the first monday of a month in the future or in the past 3
How do I get the week in month from a date? 2
convert weekday date to the next sunday date 1
Show dates based on criteria 3
week numbers 3

Top