Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement MONTH function #1004

Closed
stanim opened this issue Aug 19, 2021 · 0 comments · Fixed by #1005
Closed

Implement MONTH function #1004

stanim opened this issue Aug 19, 2021 · 0 comments · Fixed by #1005
Projects

Comments

@stanim
Copy link
Contributor

stanim commented Aug 19, 2021

Description

Returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).
https://support.microsoft.com/en-us/office/month-function-579a2881-199b-48b2-ab90-ddba0eba86e8

Syntax

MONTH(serial_number)

The MONTH function syntax has the following arguments:

  • Serial_number Required. The date of the month you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
@stanim stanim mentioned this issue Aug 19, 2021
10 tasks
xuri added a commit to stanim/excelize that referenced this issue Aug 21, 2021
xuri pushed a commit that referenced this issue Aug 21, 2021
@xuri xuri added this to Features in v2.5.0 Sep 26, 2021
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
No open projects
v2.5.0
Features
Development

Successfully merging a pull request may close this issue.

1 participant