Return date range

[klynn]

My spreadsheet has a list of dates in one column. I need to know the week each date falls into. Sunday to Saturday.
Example" if a1 has a value of 09/18/2003 I am looking for a formula that will bring back the week range for that date. Range starting with Sunday-Saturday. In this case the return in b1 would be 09/14/2003 - 09/20/2003.

Any help would be greatly appreciated.
Thanks

 

[Yogi Anand]

Hi klynn:

Please look at the following simulation ...

Book1
	A	B	C	D
1	Date	SundayOfWeek	SaturdayOfWeek
2	09/18/03	09/14/03	09/20/03
3	08/18/03	08/17/03	08/23/03
4	07/18/03	07/13/03	07/19/03
Sheet1

Does it help? If I have misunderstood your question -- my apologies!

 

[klynn]

Yogi, Thank you very much for your help. Your reply was exactly what I was looking for.