THe Last DATE of the previous month from today

C

CmK

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
 
M

Mike

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)
 
T

Toppers

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


Mike said:
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)
Click to expand...
 
R

Ron Rosenfeld

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
Click to expand...

=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
 
P

Philip J Smith

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
 
Top