Forum Discussion
Emilydb0310
Mar 06, 2024Copper Contributor
Excel short date - month and year change only
Hello, I have a spread sheet that has dates as example below: 29/03/2022 04/02/2021 11/06/2023 However I need to change the month and year only but keep the same day, so it looks like this: 29/...
Maciej_Kopczynski
Mar 06, 2024Brass Contributor
Hi!
There are many ways you can try, but assuming you want your year to be 2024 and month april for all your dates just try this formula:
=DATE(2024, 4, DAY(D10))
My formula is in E10 and references the date in D10. Adjust the referencing and drag and drop!
Leap years won't be a problem because 2024 is fortunately also a leap year so there won't be errors for 29.02 either.