PDA

View Full Version : Solved: Last Date of Last Month



itipu
06-12-2007, 04:33 AM
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
06-12-2007, 04:45 AM
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"yyyymmdd")

itipu
06-12-2007, 04:56 AM
objExcel.Cells(x, 4).Value = TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"yyyymmdd")

Highlights YEAR and says Expected: )



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

itipu
06-12-2007, 05:13 AM
Solved!

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

mdmackillop
06-12-2007, 05:37 AM
Can you clarify this?

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

itipu
06-12-2007, 06:06 AM
Clarify "Thanks a lot"?

Or clarify the solution?