Solved: Last Date of Last Month

[itipu]

I am trying to get some way of printing out last date of last month.

So if today is 12th of June 2007 I want to have - 20070531...

Any help is much appreciated!

Thanks a lot
Mike

[Bob Phillips]

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"yyyymmdd")

[itipu]

objExcel.Cells(x, 4).Value = TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"yyyymmdd")

Highlights YEAR and says Expected: )



Thanks a lot again !!!!!!!!

[itipu]

Solved!

Format(DateSerial(Year(Now()), Month(Now()), 0), "yyyymmdd")

[mdmackillop]

Can you clarify this?

Thanks a lot again !!!!!!!!

[itipu]

Clarify "Thanks a lot"?

Or clarify the solution?