<div>
Or, if you want the whole date value for the last day of the month:<br />
<br />
=DATE(YEAR(B2),MONTH(B2),0<wbr />)<br />
<br />
Kevin
</div>


Or, if you want the whole date value for the last day of the month:

=DATE(YEAR(B2),MONTH(B2),0)

Kevin

<div>
Thanks Kevin!<br />
<br />
Seamus
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have some formula which returns me the 1st day of the month (-1) based on todays date<br />
<br />
So today, i would get 01/04/2011 based on 13/05/2011<br />
<br />
I want to amend that so i get the last calender day of the month, so today i would get 30/04/2011<br />
<br />
My formula is =DAY(DATE(YEAR(B2),MONTH(B<wbr />2)+1,1)-1)<wbr /><br />
<br />
where B2 = Today()<br />
<br />
Thanks<br />
Seamus
</div>
</div>


Hi,

I have some formula which returns me the 1st day of the month (-1) based on todays date

So today, i would get 01/04/2011 based on 13/05/2011

I want to amend that so i get the last calender day of the month, so today i would get 30/04/2011

My formula is =DAY(DATE(YEAR(B2),MONTH(B2)+1,1)-1)

where B2 = Today()

Thanks
Seamus

Last months date

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.