Forum Discussion
Add 1 Year to the Second to a Date
Hi! I have a need to add 1 year to the second to a date in Excel. For example: Start: 3/16/2026 4:06:28 PM MST End: 3/16/2027 4:06:28 PM MST I know that EDate can be used to easily add 1 year ...
Hellomtthomasm516,
Use the formula =EDATE(A1,12)+MOD(A1,1) where A1 contains the original datetime. This adds 12 months to the date portion and preserves the time portion exactly.