Date generation

Hi everybody

I am trying to prepare an excel where if I select date, month, year from 'drop down' in 3 different cell
A2- Date
B2-Month
C2-Year
I want that full date (dd mmm, yyyy) to be generated in another cell.
D2- dd mmm yyyy

Thanks in advance for your assistance

Regards,
Tanza

Please Login or Register  to view this content.

I tried the formula. It is working. Thanks a lot.

Best regards,
Tanza

Originally Posted by DonkeyOte

see the DATE function (or translated equiv. pending local version)

Please Login or Register  to view this content.

Format D2 as dd mmm, yyyy

If you want the above as a literal string then apply outer TEXT

Please Login or Register  to view this content.

Generally better to store dates as dates (ie number) however

Hi,
In my excel day, month, year to be selected from dropdown list (cell A2, B2, C2)
In D2 the total date will be generated in dd-mmm-yyyy format
I applied formula
=TEXT(DATE(C2,B2,C2),"dd mmm, yyyy")
Its working fine.
But if by mistake i select any date like 31 april 2011, in D2 the date refelecting 01 May 2011 because April is 30 days.
Is there anyway I can turn it to blank when I select a day which is not available in that month. Lets say 31 Feb

Thank you
Tanza