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