YEAR,MONTH,DAY,HOUR,MINUTE,SECOND functions. Extract the year, month, date, time, minute, and second.(Microsoft Excel)

kohki08

1 month ago

Extract the year, month, date, time, minute, and second.

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)

If you specify the argument the cell range, it will be Spill.

---