Google Sheets

7 views

Skip to first unread message

Harkins Construction

unread,

Mar 20, 2025, 2:58:15 AMMar 20

to Google Sheets Community

Hi I am new to google sheets and I am trying to figure out the formula I would use to get a date 10 years from a start date for a warranty purpose. So I put in one cell when job was completed, so that becomes the start date and in the next column I need to know what date it will be in ten years. So I am assuming it is an add 3650 days???? So confused by what this formula would be but it seems like it should be so simple. If anyone can help it would be so appreciated!

Thanks Wendy

Valmir

unread,

Mar 20, 2025, 7:59:12 AMMar 20

to Google Sheets Community

hi,

considering the date is in cell A1, try this:

=DATE(YEAR(A1)+10; MONTH(A1); DAY(A1))

Gina Maylone

unread,

Mar 20, 2025, 8:30:51 AMMar 20

to Google Sheets Community

If your date in in A1 use this formula: =EDATE(A1, 120) adds 120 months.

Reply all

Reply to author

Forward

0 new messages