how by formula can i repeat the same date with change only in the - Microsoft Community

example:           what need  (by formula below bold dates fo each 3 months & 3 years)    

what have           what need                                                     need

                               repeat date every 3 months                          repeat date every 3 years  

4-jul-2016              4-jul-2016                                                         4-jul-2016

                               4-oct-2016                                                      4-jul-2019

                               4-jan-2017                                                      4-jul-2022

thanks

a1: first date

b1: = date(year(a1),month(a1)+1,day(a1))  'increments 1 month

b1: = date(year(a1),month(a1)+3,day(a1))  'increments 3 months

c1: = date(year(a1)+1,month(a1),day(a1))  'increments 1 year

c1: = date(year(a1)+3,month(a1),day(a1))  'increments 3 years

Office / Excel / Windows 8 / Office 2013