Forum Discussion
Date range
I need to put a date by week in a cell and copy (i.e. 12/1/23 - 12/7/23 and then in next cell 12/8/23 - 12/14/23 and so on down the list. Can this be done automatically.
=TEXT(A1,m/d/yy")&" - "&TEXT(A1+6,"m/d/yy"). Keeps telling me there is an error. What am I doing incorrectly?
I got it. Thank you so much! You are a lifesaver.
- You're very welcome.
