Functions in Excel
=date()
=date()
When we work in Excel it is very important to understand how
date calculations work. Date functions plays a vital role in this. For users
excel display the date in understandable format but actually excel treat dates
as a number while processing.
Some time in
development environment clients will send the in notepad and you need to import
that data into excel with date a text format, in those situation we can use the
=date() functions and get the accurate date.
Excel stores dates
as a serial no and to know about that serial no we need to use =date()
function.
Date functions uses
Year, Month, Day as an argument.
Get the serial no of date
Get the date from text value
Date is the
main function to work with dates in excel but there are lot of functions are
available. In coming days we will go one by one with these functions.
Keep Learning
Sanjay Bakshi
mesanjaybakshi@gmail.com
No comments:
Post a Comment