I need to round all dates that are between the 2nd and 15th (both #'s included) up to the 15tht and all dates that are between the 16th to the 31st (both #'s included) to the 1st of the next month.
Thanks Danny but doesn't give me a correct answer. For example in i put 12/27/10 i got 1/13/10. It should be 1/1/11.
I was trying =IF(AND(DAY(B9)>1,DAY(B9)<=15),DATE(YEAR(B9),MONTH(B9),15),DATE(YEAR(B9),MONTH(B9)+1,1)) but only get the date to the 1st but can't get the 15th.