Creating date objects from multiple cells.
Posted by Chris M. on December 13, 2001 4:31 PM
I'm trying to put a date togeather from different cells. I'll have a day in one cell and a month in another. I want to put them togeather to make a date in one cell. I'm trying to do this in VBA.
Obviously this is wrong, but to try and help you understand what i'm trying to do.
Date1
month = cells(x,1)
day = cells(x+5,4)
year = 2001
Cells(x,2) = Date1
I know this is probably really obvious, but I can't figure it. I'm obviously not a programmer, but I'm trying. Thanks.