date confusion

[evelin via OfficeKB.com]

hi
I have set in program cell(x,2).numberformat = Dateserial(dd-mm-yy).
but while running program if cells(x,2).value= cells(x.2)+1 or cells(x,2).
value=Dateserial(yr+1,mth,dt), or cells(x,2).value=Dateserial(yr,mth,dt+1)
etc is done not always working properly if tody it works tomorrow it won't

A kinder garten type question, I know . still i long for help
thanks

 

[Rick Rothstein]

The value returned from the DateSerial function is a Date, not a String...
the NumberFormat property requires a (format pattern) String. Try it this
way...

Cell(x, 2).NumberFormat = "dd-mm-yy"

 

[evelin via OfficeKB.com]

hi Rick Rothstein
Thanks i have to try that