Difference between revisions of "Manuals/calci/MONTHEND"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
==Description== | ==Description== | ||
*This function showing the final date of every month in the normal year. | *This function showing the final date of every month in the normal year. | ||
| − | * | + | *<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 | ||
| + | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=XqJJ1S8ENs4|280|center|Month}} | ||
| + | |||
| + | ==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 ]] | ||
Latest revision as of 14:54, 15 February 2019
MONTHEND
Description
- This function showing the final date of every month in the normal year.
- 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 |
Related Videos
See Also
References