One way:
=DATE(L1*100+K1,H1,J1)
In article ,
Metalteck wrote:
I have a spreadsheet that has 4 columns.
H=Month, ex 4
J=Day , ex 1
K=Year, ex 5
L=Century, ex 20
How can I gather all of these fields so that it can look like 4/1/2005 and
dragged down to 400 times?
|