Possible to have a date in one column automatically generate from another date column?

New Contributor

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!

5 Replies
this simpliest option is to add 365.25*2 for that number of days or +720.5:
=A1 + 730.5

@PaigeAlley Alternativel, use something like:


That works beautifully!
Follow-up question, how can I make it so that if G is blank H stays blank, but will show the generated date once G is updated?
Or, is it possible to write in values for H that will then be replaced when G is updated?

Sorry if that doesn't make sense