How to get last date of a month when I have just year and month in separate fields as string? For example, I have month as 1 and year as 2019 and I want to get the last date for this (which is 31). If I have month as 2 and year as 2019, I want to get 29
Input data
Month | Year |
1 | 2019 |
2 | 2019 |
3 | 2019 |
Output data required
Month | Year | LastDate |
1 | 2019 | 31 |
2 | 2019 | 29 |
3 | 2019 | 31 |
Solved! Go to Solution.
Hello @shravanvijayaprasad,
this is one created for 2020. You only need to input the first day of the year on the first formula.
Regards