Excel 2003 - VBA - Working with Dates

  • Thread starter Thread starter Craig Brandt
  • Start date Start date
C

Craig Brandt

Does anyone have and idea how to create the date of the last day of the
previous month?

Craig
 
Hi Craig

=Dateserial(year(date), month(date), 0)

HTH. Best wishes Harald
 
Assuming the OP actually needs this in VBA (as his Subject seems to
indicate), the VB equivalent of your worksheet formula is this...

LastDayOfPreviousMonth = Date - Day(Date)
 
Thanks for all your help. The entry showing the code for VBA nailed it.

Craig
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting based on dynamic Date 1
Problem with Excel Dates 11
Excel 2003 - VBA - Date Math 11
Excel Monthly Spread sheet. 12
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Dates American English? 2
Excel Vba to change displayed year automatically. 14
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3

Back
Top