YEAR,MONTH,DAY,HOUR,MINUTE,SECOND functions. Extract the year, month, date, time, minute, and second.(Microsoft Excel)
Extract the year, month, date, time, minute, and second.
Contents
How it works
=YEAR(Serial_number)
=MONTH(Serial_number)
=DAY(Serial_number)
=HOUR(Serial_number)
=MINUTE(Serial_number)
=SECOND (Serial_number)
| Argument | Omission | Specify |
|---|---|---|
| Serial_number | Required argument. | Target date and time (serial value) |
Example Results
Spill
If you specify the argument the cell range, it will be Spill.
---