• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

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?
1 Solution
zorvek (Kevin Jones)ConsultantCommented:
Try this formula:


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.
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now