Formula Tanggal dan Waktu

Ada beberapa Formula Tanggal dan Waktu diantaranya : Day | Hour | Minute | Month | Networkdays | Now | Second | Today | Weekday | Year
--------------------------------------

Day
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
--------------------------------------

Hour
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 hour
--------------------------------------

Minute
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
--------------------------------------

Mounth
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
--------------------------------------

Networkdays
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
--------------------------------------

Now
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
--------------------------------------

Second
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
--------------------------------------

Today
What is the use of Today formula?
Today's date

Syntax of Today formula:
today()

Examples of Excel Today formula:
today() = today's date
--------------------------------------

Weekday
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
--------------------------------------

Year
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

--------------------------------------

Sumber : http://chandoo.org/