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

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! :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Xbox One X is the final name of Project Scorpio 4
Nintendo Switch release date and details 2
'Father of Android' Andy Rubin is plotting a return to hardware 0
HMS Queen Elizabeth using out-dated Windows XP 4
Max-Q GTX 1070 in ultra slim chassis – GS63VR 7RG Stealth Pro Intro 4
Outstanding Design and Performance - Deep Look into New MSI GE63VR 7RF Raider 3
Cortana and Alexa to work together. 1
Amaze/Delrina Daily Planner on Windows 10 and beyond... 3

Back
Top