Difference between revisions of "Manuals/calci/MONTHEND"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
*In <math>MONTHEND</math> used to show the all the final date in each month. | *In <math>MONTHEND</math> used to show the all the final date in each month. | ||
*Also it is not considering leap year. | *Also it is not considering leap year. | ||
| − | *MONTHENDLEAP can be used to show the final date in the leap year. | + | *[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP ]] can be used to show the final date in the leap year. |
*Normal year and leap year is having the difference in February month only. | *Normal year and leap year is having the difference in February month only. | ||
*The final date of each month in Normal year is : | *The final date of each month in Normal year is : | ||
| Line 20: | Line 20: | ||
** November - 30 days | ** November - 30 days | ||
**December - 31 days | **December - 31 days | ||
| + | |||
| + | ==Examples== | ||
| + | #MONTHEND | ||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | | 31 || 28 || 31 || 30 || 31|| 30 || 31 || 31 || 30 || 31 || 30 || 31 | ||
| + | |} | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/MONTHENDLEAP | MONTHENDLEAP ]] | ||
| + | *[[Manuals/calci/DATE | DATE ]] | ||
| + | *[[Manuals/calci/YEAR | YEAR ]] | ||
| + | |||
| + | ==References== | ||
| + | *[https://exceljet.net/excel-functions/excel-month-function Month] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Revision as of 13:53, 16 August 2017
MONTHEND
Description
- This function showing the final date of every month in the normal year.
- In used to show the all the final date in each month.
- Also it is not considering leap year.
- MONTHENDLEAP can be used to show the final date in the leap year.
- Normal year and leap year is having the difference in February month only.
- The final date of each month in Normal year is :
- January -31 days
- February - 28 days
- March - 31 days
- April - 30 days
- May - 31 days
- June - 30 days
- July - 31 days
- August -31 days
- September - 30 days
- October - 31 days
- November - 30 days
- December - 31 days
used to show the all the final date in each month.Examples
- MONTHEND
| 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 |
See Also
References