B
BM
Is it possible to easily round up from 9/15/06 to 10/1/06?
Thanks in advance for the help.
Thanks in advance for the help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
Would this suffice ....
=IF(DAY(A1)>=15,EOMONTH(A1,0)+1)
HTH
=IF(DAY(A1)>=15,EOMONTH(A1,0)+1)
HTH
B
BM
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?
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?
P
paul
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.
used to calculate etc.Yes.In your other cells just type =b1 and format them
as a date.
B
BM
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.
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.
P
paul
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
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