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