Date Range based on another Date

[[email protected]]

Hi,

I have a column (let's say it's column A) and it has dates, starting from Jan, 1 2014 thru today. I want in column B, to have a Sunday-Saturday date range based on the date in column A. Also, I need the year to be droped.

For example,

Column A Column B
1/1/2014 1/1-1/4
1/3/2014 1/1-1/3
1/6/2014 1/5-1/11
1/8/2014 1/5-1/11
1/9/2014 1/5-1/11

[Ace_XL]

Try..

=TEXT(MAX(DATE(2014,1,1),A1-WEEKDAY(A1)+1),"mm/dd")&"-"&TEXT(A1-WEEKDAY(A1)+7,"dd/mm")

[[email protected]]

Hi,

Thank you but it does not seem to be working. See screen shot.screen shot.PNG

[[email protected]]

I see the problem. The dd/mm needs to be mm/dd.

TEXT(MAX(DATE(2014,1,1),A16-WEEKDAY(A16)+1),"mm/dd")&"-"&TEXT(A16-WEEKDAY(A16)+7,"mm/dd")