On Wed, 28 Feb 2007 06:24:44 -0800, 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

=TODAY()-DAY(TODAY())

or, with any date in A1, the last day of the previous month is:

=A1-DAY(A1)

Since you're an accountant, perhaps you want the last business day of the
previous month?

=WORKDAY(A1+1-DAY(A1),-1,Holidays)

where the WORKDAY function requires the Analysis Tool Pak to be installed; and
Holidays is an optional named range containing holiday dates.

or

=WORKDAY(TODAY()+1-DAY(TODAY()),-1,Holidays)


--ron