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

Thanks in advance for the help.

Would this suffice ....

=IF(DAY(A1)=15,EOMONTH(A1,0)+1)

HTH

"BM" wrote:

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

Thanks in advance for the help.

That absolutely works. I should have asked this question.

If b1 is where the user types in the date and you only want them to have to
enter the date one time, this is on a form, is this possible?

"BM" wrote:

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

Thanks in advance for the help.

you mean type tha date in one cell and have it show up in other cells and
used to calculate etc.Yes.In your other cells just type =b1 and format them
as a date.
--
paul

remove nospam for email addy!



"BM" wrote:

That absolutely works. I should have asked this question.

If b1 is where the user types in the date and you only want them to have to
enter the date one time, this is on a form, is this possible?

"BM" wrote:

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

Thanks in advance for the help.

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.

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.