Mike R wrote:
Thank you Ron for looking back at this post
What I have is an employee timesheet. This particular one runs the
accumulated time worked for one employee an entire month. The only thing
left on the project that I am having trouble with is this date thing. Cell
C6 (Formatted ddd mmmm dd yyyy) is the input cell for the date, cell H6
(Formatted mmmm dd yy) is the expected date for the end of the month. This
cell contains your formula. Thank you for the formula!!! I placed an object,
calendar control 9.0 on the sheet and used Ron de Bruins code to reference
the active cell (C6) and place the €śselected€ť date into that cell. After
€śselecting€ť the appropriate date and tabbing out of the cell the calendar is
hidden. After unchecking the transition formula evaluation option, thank you
Peo, almost everything works. Because I have the object (calendar) it is
easy to €śclick€ť through the dates to see if all is working correctly. The
days in Aug including the 11th through to and including the 1st of Sept. are
the only ones that do not work properly, 22 days!! With those dates I get
##################. I get the same results without the object by inputting
the dates by hand. I get the same thing with the macros disabled. %#@#@%%&
I found the problem, and am a little shamed by it. The column was to narrow
for my formatting!!! Didnt need to post this but thought there was a lesson
in it. Because I went through the problem as you guys requested information
I was able to find the solution. As dumb as it was I should have looked
there first. Thanks for the help guys!!!!
"Ron Rosenfeld" wrote:
On Tue, 18 Jan 2005 13:33:03 -0800, Mike R
wrote:
Peo
Thank you for the post!!! That solved 95% of the problems. Now, with Ron's
last day of the month formula everything works with the ecception of Aug 11
thru 31 and Sept 1. When I go back to my original formula all works with the
exception of the month of Sept. I am beginning to think I am supposed to
just take vacation in late summer and not try to use this worksheet!!!! any
other words of wisdom? (Beside just take the vacation, although that is an
option I would like this sheet to work). Thank you again for the help!!!
You need to post more detail to describe exactly what you are doing, what
formulas and data you are using, and what your actual and expected output is.
--ron
I'm glad you got things working to your satisfaction
ron
|