I have a list with dates in fields F5-F50 and want to automatically
populate G5-G50 with a date 6 months future. I am using
=DATE(YEAR(G1),MONTH(G1)+6,DAY(G1)) but how do I get it to progress
through the colums so that G5 picks up the date from F5 and adds 6
months, G6 picks up the date from G6 and so on.