How to get last date of a month when I have just year and month in separate fields

[shravanvijayaprasad]

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

[Greg_Murray · Accepted solution]

Hi, 

You can you do this with a series of formulas.

1. Create the first date for the month and year given
2.  Add one month to get the first date of the next month
3. Subtract one day from that date

[afv2688 · Accepted 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