PerfectTommy
New Member
- Joined
- Apr 8, 2002
- Messages
- 15
Hello all,
I have a worksheet with 2 columns. Column A has a date (mm/dd/yy). Column B is for a user to enter a dollar amount. In trying to make this as user friendly as possible, I have set up Column A to put in the next day's date when there is an entry in Column B.
(Sorry, the columns won't line up)
Column A Column B
4/1/02 $10.00
4/2/02
When using the worksheet, the user must enter the first date (in cell A1) then the rest of the dates are calculated with a simple formula (=A1+1)copied in the next 30+ cells. This works nicely until the end of the month when the date "rolls over" to the next month.
Column A Column B
4/30/02 $10.00
5/1/02
My question (finally): Is there a way to stop the "roll over" and have the period end at the last day of the month? I realize I will probably have to change the formula used to produce the date, and that is not a problem.
Thanks in advance for your assistance.
This message was edited by PerfectTommy on 2002-04-19 10:08
This message was edited by PerfectTommy on 2002-04-19 10:09
This message was edited by PerfectTommy on 2002-04-19 10:12
I have a worksheet with 2 columns. Column A has a date (mm/dd/yy). Column B is for a user to enter a dollar amount. In trying to make this as user friendly as possible, I have set up Column A to put in the next day's date when there is an entry in Column B.
(Sorry, the columns won't line up)
Column A Column B
4/1/02 $10.00
4/2/02
When using the worksheet, the user must enter the first date (in cell A1) then the rest of the dates are calculated with a simple formula (=A1+1)copied in the next 30+ cells. This works nicely until the end of the month when the date "rolls over" to the next month.
Column A Column B
4/30/02 $10.00
5/1/02
My question (finally): Is there a way to stop the "roll over" and have the period end at the last day of the month? I realize I will probably have to change the formula used to produce the date, and that is not a problem.
Thanks in advance for your assistance.
This message was edited by PerfectTommy on 2002-04-19 10:08
This message was edited by PerfectTommy on 2002-04-19 10:09
This message was edited by PerfectTommy on 2002-04-19 10:12