=DATE(YEAR(NOW()),(MONTH(NOW())-1)+1,0)
with todays date in A1 try

"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