Hello, I am currently using this formula =TEXT(DATE(2012, 1, 1)+(ROW(1:1)-1)*7, "mm/dd/yy")&"-"&TEXT(DATE(2012, 1, 1)+(ROW(1:1)-1)*7+6, "mm/dd/yy") to give me the range of every week.
That works but when it reaches the end of month it continues in the same cell. Is it possible so at the end of the month the range would stay within the month instead of increasing to next month?
Here let me try to explain visually.
01/01/12-01/07/12
01/08/12-01/14/12
01/15/12-01/21/12
01/22/12-01/28/12
01/29/12-02/04/12 <-- can this be 01/29/12-01/31/12 ?
And next month would be per week in each coulmn as well and so on.
02/01/12-02/04/12
02/05/12-02/11/12
02/12/12-02/18/12
02/19/12-02/25/12
02/26/12-02/29/12
03/01/12-03/03/12
I hoped I explained that correctly. I have been looking for a solution for what seems like forever and any help would be appreciated.
Thank you.
Bookmarks