Forum Discussion
mtthomasm516
Mar 19, 2026Copper Contributor
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 ...
Detlef_Lewin
Mar 20, 2026Silver Contributor
=EDATE(A1,12)+MOD(A1,1)