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

Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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! :)
 

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
'Father of Android' Andy Rubin is plotting a return to hardware 0
HMS Queen Elizabeth using out-dated Windows XP 4
Amaze/Delrina Daily Planner on Windows 10 and beyond... 3
Discovery UK is threatening to pull its channels from Sky over money disputes 6
Access Count dates within a Month 4
CCleaner Compromised to Distribute Malware for Almost a Month 10
Extracting Dates 4

Top