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.

Sign up for GitHub

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

Jump to bottom

Implement DAY function #1002

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

Implement DAY function #1002

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

Comments

@stanim
Copy link
Contributor

stanim commented Aug 19, 2021

Description

Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
https://support.microsoft.com/en-us/office/day-function-8a7d1cbb-6c7d-4ba1-8aea-25c134d03101

Syntax

DAY(serial_number)

The DAY function syntax has the following arguments:

  • Serial_number Required. The date of the day 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.

Output of go version:

go version go1.17 linux/amd64
@stanim stanim mentioned this issue Aug 19, 2021
Merged
10 tasks
xuri added a commit to stanim/excelize that referenced this issue Aug 21, 2021
@xuri
This closes qax-os#1002, new fn: DAY ref qax-os#65
5537e84
xuri added a commit that referenced this issue Aug 21, 2021
@stanim @xuri
This closes #1002, new fn: DAY ref #65
935af2e 
Co-authored-by: Stani Michiels <git@rchtct.com>
Co-authored-by: xuri <xuri.me@gmail.com>
jenbonzhang pushed a commit to jenbonzhang/excelize that referenced this issue Oct 22, 2023
@stanim @xuri
This closes qax-os#1002, new fn: DAY ref qax-os#65
2b5bd2a 
Co-authored-by: Stani Michiels <git@rchtct.com>
Co-authored-by: xuri <xuri.me@gmail.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Implement DAY function stanim/excelize
1 participant
@stanim