you can format the cell b1 to read august when you type in any date in august
but you would need a different dispaly cell to show the rounding up,because
your typing in the date would overwrite any rounding up formula,unless you
want to have a macro.What you need to do is have an input cell for the date
say A1 and have Toppers formula in B1 and work of that.By the way an easy way
to enter todays date is hold down ctrl and hit ; ctrl and shift and ; enters
the time
--
paul

remove nospam for email addy!



"BM" wrote:

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.