creating a date using data from multiple fields

[sgthammers]

Hello.

I need to fill a date entry with values from three fields.

The Result needs to be in yyyymmdd format, with the three feeder fields listing the yyyy, mm, dd values as four or two character fields respectively (I need the date to show 8 characters).

For example, I enter:

02 (in the month field)
01 (in the day field)
2007 (in the year field)

and get 20070201 in the date field. Any suggestions?

Thanks for the help!

 

[Andrew Poulsom]

Try, eg:

=A3&TEXT(A1,"00")&TEXT(A2,"00")

or:

=DATE(A3,A1,A2)

formatted as yyyymmdd for a true serial date.

 

[sgthammers]

Thanks a lot Andrew! That fixed it and made me look good to my Sergeant Major!