Forum Discussion
PaigeAlley
Oct 21, 2022Copper Contributor
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 Colum...
mtarler
Oct 21, 2022Silver Contributor
this simpliest option is to add 365.25*2 for that number of days or +720.5:
=A1 + 730.5
=A1 + 730.5
PaigeAlley
Oct 21, 2022Copper Contributor
Thank you!