THe Last DATE of the previous month from today
 

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

THe Last DATE of the previous month from today
 

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

THe Last DATE of the previous month from today
 

=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

THe Last DATE of the previous month from today
 

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

THe Last DATE of the previous month from today
 

=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

THe Last DATE of the previous month from today
 

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

THe Last DATE of the previous month from today
 

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