help with dates - beginning the week of

[unit213]

If I have 7/26/2006 in cell A1, what formula can I use to return the
the "week of" 7/24/2006?

I have a range of data that's 50,000 rows deep containing different
dates. I need to find out what week they begin in using dates, not
the weeknum function.

Thanks in advance for the help!

 

[West Man]

Try: =A1-CHOOSE(WEEKDAY(A1),0,1,2,3,4,5,6)

 

[unit213]

Try: =A1-CHOOSE(WEEKDAY(A1),0,1,2,3,4,5,6)

Thanks for your input. Your forumula gets me very close to where
I need to be. However, it returns a Sunday as being the first
day of the week. In my scenario, I need that to be Mondays.

How would I adjust the formula above for that?

 

[unit213]

It looks like adding a 1 at the end of the formula did the trick.

Thanks!

 

[Richard Schollar]

An alternative

=A1-WEEKDAY(A1,2)+1

 

[unit213]

Perfect! Thank you.

 

[barry houdini]

...or...

=A1-WEEKDAY(A1,3)