I have searched everywhere for this and I can't seem to find it, maybe there is a better way to explain what I need??
Does anyone know if there is a way to combine a date with text and still be able to add a month so the spreadsheet updates itself if you change one of the dates?
For example, lets say you had a spreadsheet with the following columns:
Jan Sales
Feb Sales
Mar Sales
And so on until December
Is there a formula that I can use so that if the first one changes from Jan Sales to say Apr, the rest of the dates in each column will update automatically?
Bookmarks