Forum Discussion
Possible to have a date in one column automatically generate from another date column?
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!
PaigeAlley Alternativel, use something like:
=EDATE(G2,24)
- 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- =IF(G2="","",EDATE(G2,24))
- this simpliest option is to add 365.25*2 for that number of days or +720.5:
=A1 + 730.5- Thank you!
