EXCEL - 11
DATA AND TIME FUNCTIONS
TODAY
NOW
DAYS
DATEDIF
NETWORKDAYS | NETWORKDAYS.INTL
DATE
YEAR
MONTH
DAY
EOMONTH
TIME
HOUR
MINUTE
SECOND
DATEVALUE
TIMEVALUE
DATE FORMAT :- DD/ MM / YYYY
Whenever we input time in an excel without any format, we get a number which is
1/1/1900 - (dd/mm/yyyy) you enter a data number. If we use number and decimal in it without changing the format we get time also with the data. We have to change the format as per our need and demand.
Current date = today()
=TODAY()
But it will change every day.
We want today’s date but fix it. Ctrl + ;
Current time = now()
=NOW()
But it will change every day.
We want today’s date but fix it. Ctrl + SHIFT + :
DAYS :- Calculates the number of days between two dates.
=DAYS(end_date, start_date)
Datediff :- DIFFERENCE BETWEEN dates :-
=DATEDIF(start_date, end_date, "unit")
we can get year, month, days, month-day, year-month.
Networkdays : - It helps us to network working days, we can NOT decide the weekends DAYS.
=NETWORKDAYS(start_date, end_date, [holidays])
Networkdays.INTL : - It helps us to network working days, we can decide the weekends DAYS.
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
YEAR
=YEAR(date)
Extracts the year from a date.
MONTH
=MONTH(date)
Extracts the month from a date.
DAY
=DAY(date)
Extracts the day of the month from a date.
The above function gives us their name from a given date.
EOMONTH - Returns the last day of the month, a specified number of months before or after the start date.
=EOMONTH(start_date, months)
Time -Returns the serial number of a particular time..
=TIME(hour, minute, second)
HOUR
=HOUR(time)
Extracts the hour from a time.
MINUTE
=MINUTE(time)
Extracts the minute from a time.
SECOND
=SECOND(time)
Extracts the second from a time.
DATEVALUE
=DATEVALUE(date_text)
Converts a date in the form of text to a serial number.
TIMEVALUE
=TIMEVALUE(time_text)
Converts a time in the form of text to a serial number.
In summary, data validation is a powerful tool in Excel that enhances data accuracy and efficiency.
Follow me on this where every day will be added if i learn something new about it :- https://dev.to/nitinbhatt46
Thank you for your time.
Top comments (0)