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?