Combine data in 3 separate fields into useable date

**Jannoth** · 04-16-2013, 04:31 AM

Hi,

This question relates to Excel 2010 and is weird ... so please excuse the dippy question.

I'm using the DATE= function to assemble three values but getting the wrong answer.

F22 = 6
G22 = 4
H22 = 2012

In cell F23, =DATE(F22,522,H22) gives the result 03/12/1954 not 06/04/2012

In Excel's regional settings, the location is English (UK) and the PC runs Windows 7, which shows the location as United Kingdom with a format of English (United Kingdom).

The context is that each year, I want to change the financial year in just one central cell, B1 (eg = 2013) and all cells update automatically.

Thanks for any help

**Lemice** · 04-16-2013, 05:03 AM

Hello,

In the DATE function, it appears to me as =DATE(year, month, day)
So what you can do is try this

Please Login or Register  to view this content.

Hope this help.

**Jannoth** · 04-16-2013, 05:19 AM

Hi Lem and thanks.

I knew it had to be something dozey and it worked immediately.

Thanks

**tatar_ramazan** · 04-16-2013, 08:10 AM

Hi,

if you enter the formula =VALUE(CONCATENATE(F22;".";G22;".";H22)) the result will be a serial number.

Then from format cells (ctrl+1) date format will bring the solution.

Regards