First Day of Last Month 2

[wvmbark]

If "=DateSerial(Year(Date()),Month(Date()),1)" returns first day's date of current month, how can I get the date of last month's first day?

Thanks for the help?

 

[mpastore]

?dateadd("m",-1,date())-format(dateadd("m",-1,date()),"d&quot+1

 

[jebry]

Hi!

Try this:

=DateSerial(Year(Date()),IIf(Month(Date())=1,12,Month(Date())-1),1)

hth


Jeff Bridgham
bridgham@purdue.edu

 

[MichaelRed]

MyDate = Date
? Dateserial(Year(MyDate), Month(MyDate), 0)
4/30/03

???????????????




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[mpastore]

MichaelRed

He wanted 1st day of prior month, not last

 

[MichaelRed]

????????????? so solly so saaaad




MichaelRed
m.red@att.net

Searching for employment in all the wrong places