Round dates from 1to 15 to 1st and 16 to 31 to 16th of same month

[jitender7568]

13/01/2017 then it should come 01/01/2017
27/01/2017 then it should come 16/01/2017

 

[Becky]

This should work (where A1 is the date you want to change):

=IF(DAY(A1)<16,DATE(YEAR(A1),MONTH(A1),1),DATE(YEAR(A1),MONTH(A1),16))

Hope this helps!