Oct 21 2022 08:56 AM
I feel like this should be possible but I'm not quite sure how to do it!
I'm trying to set it up so that when I type a date into column G (Date Renewal Completed), it will generate a date into Column H (Next Renewal Date) that is the same month but 2 years in the future. This is for a rather large worksheet and would save a lot of time in the long run if I could just have it auto-generated!
For example:
|Date Renewal Completed | Next Renewal Date |
| 2/22/2022 | February 2024 |
Any ideas how to make this happen?
Thanks in advance!
Oct 21 2022 09:01 AM
Oct 21 2022 09:02 AM
@PaigeAlley Alternativel, use something like:
=EDATE(G2,24)
Oct 21 2022 09:09 AM
Oct 21 2022 09:09 AM
Oct 21 2022 09:46 AM