Converting into date format in excel

[baidya91]

I have selected three cells A1 = Day, B1= Month & C1=Year. Now I want to get date format in cell D1 as DD-MM-YYYY.

For example, A1=22, B1=10, C1=1975 and the result will be in D1= 22-10-1975.

How can I do that?

 

[MARK858]

Just use the DATE function and custom format the cell as dd-mm-yyyy...

Excel Workbook
	A	B	C	D
1	22	10	1975	22-10-1975
Sheet1

 

[baidya91]

Just use the DATE function and custom format the cell as dd-mm-yyyy...

Sheet1

	A	B	C	D

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:121px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1975[/TD]
[TD="align: right"]22-10-1975[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula D1 =DATE(C1,B1,A1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thanks