Sorry, let me clarify. If you type in B1 and you want B1 to be where the
date is displayed. For instance if I type 8/1/06 in B1, B1 should read
August. If I type 8/15/06 in B1 I want it to automatically adjust to Sept.

"BM" wrote:

Is it possible to easily round up from 9/15/06 to 10/1/06?

Thanks in advance for the help.