last day of the month

[spf2010]

I have a month column and a year column.I want to calculate the last day of the month going back multiple years.I also want it in a 4/30/2017 format.Also there are duplicate entries with the same month and year.

 

[Eric W]

To get the last day of the month, just use the EOMONTH function:

=EOMONTH(DATE(A1,B1,1),0)

where A1 is the year and B1 is the month. To get the 4/30/2017 format, just select that format from the date formats. Duplicates should be no problem.

Hope this helps.

 

[Rick Rothstein]

To get the last day of the month, just use the EOMONTH function:

=EOMONTH(DATE(A1,B1,1),0)

where A1 is the year and B1 is the month. To get the 4/30/2017 format, just select that format from the date formats. Duplicates should be no problem.

Why not the more direct route...

=DATE(A1,B1+1,0)

 

[spf2010]

To get the last day of the month, just use the EOMONTH function:

=EOMONTH(DATE(A1,B1,1),0)

where A1 is the year and B1 is the month. To get the 4/30/2017 format, just select that format from the date formats. Duplicates should be no problem.

Hope this helps.

The month is spelled out

 

[Jonmo1]

Try

=DATE(A1,MONTH(1&B1)+1,0)

 

[Scott Huish]

=eomonth(b1 & " 1, " &a1,0)