Sorry with the previous formula you don't need the date in A1 this one does
fererence a cell.

=DATE(YEAR(A1),(MONTH(A1)-1)+1,0)

"CmK" wrote:

Hi I just what the last date from the preious month
i am sure someone would of asked this prolbem beofore but nope I must be
the first accountant to ask this

thanks in advance