:"Master Excel date and time functions: Easily extract the month with the MONTH function"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Master Excel date and time functions: Easily extract the month with the MONTH function"

"Master Excel date and time functions: Easily extract the month with the MONTH function"

Author: daogeziyuan • • Table skills • Views 1034
```html
  • Graphic skills
  • Cases

Returns the month of a date as a serial number. Month is an integer between 1 (January) and 12 (December).

SyntaxMONTH(serial_number)

Serial_number represents a date value containing the month to be found. Dates should be entered using the DATE function or as the result of another formula or function.

For example, use DATE(2008,5,23) to enter May 23, 2008. Problems arise if the date is entered as text.

DescriptionWPS Spreadsheet can store dates as serial numbers that can be used for calculations. By default, the serial number of December 31, 1899 is 1, and the serial number of January 1, 2008 is 39448, because it is 39448 days away from December 31, 1899.

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu Oxygen_Girl Columnist
48 196
single-end

Related Suggestion