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 Colum...
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
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))
