Forum Discussion
Displaying a Date Range (i.e., 1/11/2021 to 1/17/2021) without listing the dates in between
Hi Ivan,
Could be
="Week of " & TEXT(C2,"M/D") & " to " & TEXT(D2,"M/D")
where in C2 and D2 start and end dates
Hi Ivan,
Could be
="Week of " & TEXT(C2,"M/D") & " to " & TEXT(D2,"M/D")
where in C2 and D2 start and end dates
Right on the money, Sergei! Thank you so much! that ABSOLUTELY did the trick!
On to a different question relating to the same expense report... I just created a macro that returns a blank report for the subsequent month. I begin it by clicking on the next month's tab and then proceed to have excel change all the dates (and headings, thanks to you!)... But I'm afraid if I run it at the end of May for the June report, it will wipe out all the data from May (because that's where I told it to begin).
Is there a way to have excel go to the next tab in the workbook automatically? If I can incorporate that step into my macro, I could just run it once a month and be ready to go right away.
Thank you!
Hi Ivan,
Macro is not my expertise, better if you start new conversation with that question, more chances someone answers.
