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


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.

<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.