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

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

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


"Mike" wrote:

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

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

=EOMONTH(A1,-1)

"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

Hi CmK,
THe Last DATE of the previous month from today

=eomonth(today(),-1)

regards
--
*****
birds of the same feather flock together..



"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

Hi.

While I can see what this syntax is doing, it isn't explained in the Help
section.

Do you know of a source for these "undocumented" conventions?

Regards

Phil

"Toppers" wrote:

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


"Mike" wrote:

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