Hi,
I am trying to add 6 months to a date in column A. Dates are formatted as
dd/mm/yy (UK). I have tried a few different ideas but the amended date
switches to US format. This despite the cells being formatted as UK Dates.
My current formula is =SUM(MONTH(A5))+(6)

Any ideas please?
Mickey

Start Date 6 Month Date
01/06/2005 12/01/1900
01/01/2001 07/01/1900
01/02/2001 08/01/1900
01/06/2005 12/01/1900