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?
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?
One way:
=DATE(L1*100+K1,H1,J1)
In article <[email protected]>,
Metalteck <[email protected]> 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?
Try in a spare cell
=DATEVALUE(H1&"/"&I1&"/"&J1)
And copy down. If the dates are all after 1930 and you haven't changed the
default, you shouldn't need the century
You will need to format the resulting number as a date
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS
"Metalteck" <[email protected]> wrote in message
news:[email protected]...
>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?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks