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

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?

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


"dandiehl" wrote:

> 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?
>

=A1-(WEEKDAY(A1)-2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dandiehl" <[email protected]> wrote in message
news:[email protected]...
> 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?
>

Excellent! Thank you very much.


"Ron Coderre" wrote:

> 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
>
>
> "dandiehl" wrote:
>
> > 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?
> >

=A1-WEEKDAY(A1-1)+1


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"dandiehl" <[email protected]> wrote in message
news:[email protected]...
>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?
>