Round date to the nearest entry point (1/1 or 7/1)

I have a formula that is providing me with a date. I'd like to be able to take that date and have it convert to the next entry point being either 1/1 or 7/1. So, 1/18/11 would turn into 7/1/11 and 8/15/11 would turn into 1/1/12. Any ideas?
tazpajAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
Try this formula:

=DATE(YEAR(A1),(INT((MONTH(A1)-1)/6)+1)*6+1,1)

Kevin
0
 
tazpajAuthor Commented:
That is just too easy although I'll have to wait for fresh eyes to figure out what it's doing. LOL I'm feeling really technically challenged right now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.