I agree, but the formula in B1 & B2 shows a date of 12/10/2013 when the date in A1 is (translated) 12/06/13 and B1 is 12/07/13. So your formula changes all the dates to the 10th of the month while a previous suggestion changed all the dates to the 1st of the month.