Date Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Metalteck - 02 May 2005 18:00 GMT

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?

Reply to this Message

JE McGimpsey - 02 May 2005 18:06 GMT

One way:

=DATE(L1*100+K1,H1,J1)

> I have a spreadsheet that has 4 columns.
> H=Month, ex 4
[quoted text clipped - 4 lines]
> How can I gather all of these fields so that it can look like 4/1/2005 and
> dragged down to 400 times?

Reply to this Message

Nick Hodge - 02 May 2005 18:06 GMT

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

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

>I have a spreadsheet that has 4 columns.
> H=Month, ex 4
[quoted text clipped - 4 lines]
> How can I gather all of these fields so that it can look like 4/1/2005 and
> dragged down to 400 times?

Reply to this Message