Surendra Sharma

Surendra Sharma

Search This Blog

Monday, October 6, 2014

How to convert column values in date in Excel

Recently I come across with interesting situation.

My friend called me and ask for technical help. I thought he wants to ask something in .NET or SQL Server as I am working with these technologies. But my surprise he asked me something interesting question related with Microsoft Excel.

Here is the problem

His COBOL program is generating excel file which contains month, day and year columns. He wants complete date column by applying just the excel formula in generated sheet.

Solution :

I had not any Internet connection at that time so I opened Excel in my Laptop.

Just created with text column for Month, day, Year and Final date in blank Excel file and started to play with available functions in Excel.

Microsoft already paid attention with these kind of situation by providing Date() function.

Syntax:

=DATE(year, month, day)

Just pass cell details in parameters and you will get the desired result as shown below.

Example:

= DATE(E3, C3, D3)




Please leave your comments or share this tip if it’s useful for you.

No comments:

Post a Comment