Get total number of days of each month
Written by kazamraza
no comments
Classified in : Excel Formulas, Date & Time Functions
You can get total number of days of each month by using DAY function and EOMONTH Function
| ◢ | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Data | Formula | Result | ||
| 2 | 20/Jan/2020 | =DAY(EOMONTH(A2,0)) | 31 | ||
| 3 | =DAY(EOMONTH(A2,1)) | 29 | |||
| 4 | =DAY(EOMONTH(A2,2)) | 31 |