YEAR |
YEAR(serial_number) |
Returns the year as an integer given a date serial number. |
serial_number | The date that contains the year you want to find. |
REMARKS |
* The "serial_number" can be a date value, a serial number or a reference to a cell containing a date. * If "serial_number" < 0, then #NUM! is returned. * If "serial_number" is not a valid date, then #VALUE! is returned. * You can use the DATE function to return the date as a date serial number given a year, month, day. * You can use the DATEVALUE function to return the serial number representing a date in a text format. * You can use the DAY function to return the day as an integer given a date serial number. * You can use the MONTH function to return the month as an integer given a date serial number. * You can use the NOW function to return the serial number of the current system date and time. * You can use the TODAY function to return the serial number of the current system date. * You can use the YEARFRAC function to return the number of years as a decimal between two dates. * The equivalent VBA function is VBA.YEAR * For the Microsoft documentation refer to support.microsoft.com |
|
1 - What is the current system date. This cell has been formatted with the number format "dddd, mmmm dd, yyyy". 2 - What is the current system date and time. This cell has been formatted with the number format "dddd, mmmm dd, yyyy, hh:mm". |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top