Numbers Functions
Make Numbers work for you. Check out these functions.Date and Time
DATE
=DATE( , [month], [day] )
This function accepts three parameters and combines them to form the output of a date in the format of (Y,m,d).
DATEIF
=DATEIF( [date1], [date2] )
This function returns the number of days, months and years between two dates. This is a great function to use if you want to create a countdown and date tracker within your spreadsheet.
DATEVALUE
=DATEVALE( [date text] )
This function accepts one argument of a date as a text string. Using this function will return a date value for a text string. Mostly this function is used for compatibility purposes with other spreadsheets software programs.
Example if A1 is “10/29/2014”
=DATEVALUE(A1) returns Oct 29, 2014 according to the cells format settings.
DAY
=DAY( [date] )
This function accepts one parameter that must be in the date format. It returns just the day portion of the given date.
Example
If A1 is the date Nov 13, 2015
=DAY( A1 ) returns 13
DAYNAME
=DAYNAME( [date] )
=DAYNAME( [numbers 1-7] )
This function accepts one argument which can either be a specific date formatted correctly or a number 1-7. It will return the exact word representation for the day of the week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday) where Sunday is 1.
Example
If A1 is Aug 3, 2016 and B1 is the number 5.
=DAYNAME( A1 ) returns Wednesday
=DAYNAME( B1 ) returns Thursday
DAYS360
=DAYS360( [date1], [date2], [0 or 1] )
This function accepts three arguments though the third is optional. It calculates the number of days between the two give dates under the 360 day calendar which, today, is primarily used in financial and business circles. The third argument allows the user to calculate the remaining days using the Euro method (marked as 1) otherwise the US standard NASD method is used.
Example
If A1 is Jan 8, 2016 and B1 is Mar 31, 2017.
=DAYS360( A1, B1, 0 ) returns 450 days
=DAYS360( A1, B1, 1 ) returns 449 days
EDATE
=EDATE( [start-date], [month-offset] )
The EDATE function accepts two inputs start-date and month-offset. The first input start date represents the beginning point where the second input, month-offset, is the number of months from start-date. The function will return a date that is the number of months away from start-date.
Example
If A1 is Jan 3, 2016, B1 is the number 8, C1 is the number 13.
=EDATE( A1, B1 ) returns Sept 3, 2016
=EDATE( A1, C1 ) returns Feb 3, 2017
EOMONTH
=EOMONTH( [start-date], [month-offset] )
The EOMONTH function accepts two inputs start-date and month-offset. The first input, start-date, represents the beginning point where the second input, month-offset, is the number of months from start-date. The function will return a date/time value that is the last day of the month offset from start-date.
Example
If A1 is Jan 3, 2016, B1 is the number 8, C1 is the number 13.
=EDATE( A1, B1 ) returns Sept 30, 2016
=EDATE( A1, C1 ) returns Feb 28, 2017
HOUR
=HOUR( [date/time] )
This function accepts one argument which must be a date/time value. It will return the hour value only of date/time value. The value will be returned in the 24-hour format where 0 represents midnight and 23 is 11:00 PM.
Example
If A1 is July 3, 2016 3:00 AM.
=HOUR( A1 ) returns 3
=HOUR( NOW() ) returns the current hour of the day.
MINUTE
=MINUTE( [date/time] )
This function accepts one argument which must be a date/time value. It will return the minute value only of date/time value.
Example
If A1 is July 3, 2016 3:56:22 AM.
=MINUTE( A1 ) returns 56
=MINUTE( NOW() ) returns the current minutes of the hour.
MONTH
=MONTH( [date/time] )
This function accepts one argument which must be a date/time value. It will return the month value only of date/time value. This value will be returned as a number 1-12.
Example
If A1 is July 3, 2016 3:56:22 AM.
=MONTH( A1 ) returns 7
=MINUTE( NOW() ) returns the current month of the year.
MONTHNAME
=MONTHNAME( [date/time] )
This function accepts one argument which must be a date/time value. It will return the month value only of date/time value. This value will be returned as one of the following values: January, February, March, April, May, June, July, August, September, October, November, December.
Example
If A1 is July 3, 2016 3:56:22 AM.
=MONTHNAME( A1 ) returns July
=MINUTENAME( NOW() ) returns the current month name of the year.
NETWORKDAYS
=NETWORKDAYS( [start-date], [end-date], [excluded-dates] )
This function accepts three arguments, start-date, end-date, and excluded-dates. It will return the number of weekdays excluding all Saturdays and Sundays. Optionally, you can include a list of excluded dates in the third argument of the function as well – this list must be in a date/time format.
Example
If A1 is Jan 1, 2016, B1 is Jan 31, 2016 and C1 is Jan 14, 2016
=NETWORKDAYS( A1, B1 ) returns 21d
=NETWORKDAYS( A1, B1, C1 ) returns 20d
NOW
=NOW()
This function accepts no arguments. It will return the current date and time in a date/time value.
Example
=NOW() returns the current date/time
=MONTH( NOW() ) returns the current month of the year expressed as a number value 1-12
SECOND
=SECOND( [date/time] )
This function accepts one argument which must be a date/time value. It will return the second value only of date/time value.
Example
If A1 is July 3, 2016 3:56:22 AM.
=SECOND( A1 ) returns 22
=SECOND( NOW() ) returns the current seconds of the minute.
TIME
=TIME( [hours], [minutes], [seconds] )
This function accepts three arguments: hours, minutes, seconds. It will return a date/time value by combining these three arguements.
Example
If A1 is the number 22, B1 is the number 5, and C1 is the number 13.
=TIME( A1, B1, C1 ) returns 11:05 PM
=TIME( B1, C1, A1 ) returns 5:13 AM
DAYS360
=DAYNAME( [date] )
=DAYNAME( [numbers 1-7] )
This function accepts one argument which can either be a specific date formatted correctly or a number 1-7. It will return the exact word representation for the day of the week (Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, or Saturday) where Sunday is 1.
Example
If A1 is Aug 3, 2016 and B1 is the number 5.
=DAYNAME( A1 ) returns Wednesday
=DAYNAME( B1 ) returns Thursday