Timesheet code

Well it adjusts for the Month, i.e. February had 28 days in it, but each day is being displayed with an error, the top date being #VALUE! any suggestions?

Did you put a valid year number in cell B1?

--
HTH,
Bernie
MS Excel MVP


"ChrisMattock" <[email protected]> wrote in message
news:[email protected]...
>
> Well it adjusts for the Month, i.e. February had 28 days in it, but each
> day is being displayed with an error, the top date being #VALUE! any
> suggestions?
>
>
> --
> ChrisMattock
> ------------------------------------------------------------------------
> ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
> View this thread: http://www.excelforum.com/showthread...hreadid=558817
>

Yes I have done...

=DATEVALUE($A$1& " " & ROW() - 1 & ", 2006") is the result that shows in the formula bar, but and error appears in the cell.

Chris,

It might be a regional date setting...

Does

=DATEVALUE("January 1, 2006")

produce an error?


If so, what are valid strings that DATEVALUE will work with on your computer?

HTH,
Bernie
MS Excel MVP


"ChrisMattock" <[email protected]> wrote in message
news:[email protected]...
>
> Yes I have done...
>
> =DATEVALUE($A$1& " " & ROW() - 1 & ", 2006") is the result that shows
> in the formula bar, but and error appears in the cell.
>
>
> --
> ChrisMattock
> ------------------------------------------------------------------------
> ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
> View this thread: http://www.excelforum.com/showthread...hreadid=558817
>

No that doesn't work, here are some that do... (thanks a lot for all this)


=DATEVALUE("8/22/2008")
=DATEVALUE("22-AUG-2008")
=DATEVALUE("2008/02/23")
=DATEVALUE("5-JUL")

Chris,

Try changing

Range("A2:A" & myDay + 1).FormulaR1C1 = _
"=DATEVALUE(R1C1& "" "" & Row() - 1 & "", " & myYear & """)"


to

Range("A2:A" & myDay + 1).FormulaR1C1 = _
"=DATEVALUE(Row() - 1 & "" "" & R1C1 & "" " & myYear & """)"



HTH,
Bernie
MS Excel MVP


"ChrisMattock" <[email protected]> wrote in message
news:[email protected]...
>
> No that doesn't work, here are some that do... (thanks a lot for all
> this)
>
>
> =DATEVALUE("8/22/2008")
> =DATEVALUE("22-AUG-2008")
> =DATEVALUE("2008/02/23")
> =DATEVALUE("5-JUL")
>
>
> --
> ChrisMattock
> ------------------------------------------------------------------------
> ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
> View this thread: http://www.excelforum.com/showthread...hreadid=558817
>

OR (since I forgot the dashes....)

Range("A2:A" & myDay + 1).FormulaR1C1 = _
"=DATEVALUE(Row() - 1 & ""-"" & R1C1 & ""-" & myYear & """)"

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> Chris,
>
> Try changing
>
> Range("A2:A" & myDay + 1).FormulaR1C1 = _
> "=DATEVALUE(R1C1& "" "" & Row() - 1 & "", " & myYear & """)"
>
>
> to
>
> Range("A2:A" & myDay + 1).FormulaR1C1 = _
> "=DATEVALUE(Row() - 1 & "" "" & R1C1 & "" " & myYear & """)"
>
>
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "ChrisMattock" <[email protected]> wrote in message
> news:[email protected]...
>>
>> No that doesn't work, here are some that do... (thanks a lot for all
>> this)
>>
>>
>> =DATEVALUE("8/22/2008")
>> =DATEVALUE("22-AUG-2008")
>> =DATEVALUE("2008/02/23")
>> =DATEVALUE("5-JUL")
>>
>>
>> --
>> ChrisMattock
>> ------------------------------------------------------------------------
>> ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
>> View this thread: http://www.excelforum.com/showthread...hreadid=558817
>>
>
>