What is the use of Day formula?
Tells you the day of month from a given date
Syntax of Day formula:
day(of this date)
Examples of Excel Day formula:
day("12/31/1981") = 31
day(today()) = current day
What is the use of Hour formula?
Tells you the hour from a given time
Syntax of Hour formula:
hour(at this time)
Examples of Excel Hour formula:
hour("11:30") = 11
hour(now()) = current hou
What is the use of Minute formula?
Tells you the minutes from a given time
Syntax of Minute formula:
minute(at this time)
Examples of Excel Minute formula:
minute("11:30") = 30
minute(now()) = current minutes
What is the use of Month formula?
Tells you the month from a given date
Syntax of Month formula:
month(of this date)
Examples of Excel Month formula:
month("12/31/1981") = 12
month(today()) = current month
What is the use of Networkdays formula?
Tells you how many working days are there between 2 given dates
Syntax of Networkdays formula:
networkdays(from this date, to this date, [add this holidays as well])
Examples of Excel Networkdays formula:
networkdays("12/1/2008","12/31/2008") = 23
networkdays(TODAY(),TODAY()+30) = total working days in next 30 days
What is the use of Now formula?
Today's date along with current time
Syntax of Now formula:
now()
Examples of Excel Now formula:
now() = today's date along with current time
What is the use of Second formula?
Tells you the seconds from a given time
Syntax of Second formula:
second(at this time)
Examples of Excel Second formula:
second("11:30:45") = 45
second(now()) = current seconds
What is the use of Today formula?
Today's date
Syntax of Today formula:
today()
Examples of Excel Today formula:
today() = today's date
What is the use of Weekday formula?
Tells you the day of week from a given date
Syntax of Weekday formula:
weekday(of this date)
Examples of Excel Weekday formula:
weekday("12/12/1981") = 7
weekday(today()) = current day of week
What is the use of Year formula?
Tells you the year from a given date
Syntax of Year formula:
year(of this date)
Examples of Excel Year formula:
year("12/31/1981") = 1981
year(today()) = current year
