Forum Discussion
mcadaviesuwclubnet
May 22, 2022Copper Contributor
Search and Replace date
I have a spreadsheet showing planned expenditure per month per day in format 1-Jan I would like to be able to make multiple changes - to show "1-Jan... to 1-Feb.... to 1-Mar..." Help please MIchael...
Riny_van_Eekelen
May 22, 2022Platinum Contributor
mcadaviesuwclubnet Difficult to visualise your spreadsheet but perhaps a pivot table is what you need. If you could share a bit more about how exactly your sheet looks like that would be great. A screenshot or a share (OneDrive, for example) to an example file (without private info, of course) would be better.
- mcadaviesuwclubnetMay 23, 2022Copper ContributorThanks but I have just completed the long way and changed all the dates I require!
Michael Davies