Formula to pull year from a date code and add to a string

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

mikecox39

Board Regular
Joined
Mar 5, 2014
Messages
237
My plan is to create a macro that would clear the previous fiscal year dates and replace them with the next fiscal year dates, starting with July of the current year and ending with June the following year and maybe using the result to get the year date added the the Quarterly strings on the right.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,848
Messages
5,471,118
Members
406,743
Latest member
Tinkerer01

This Week's Hot Topics

Top