date manipulation..get first of month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there an easy way to get the first day of current month - also need to
then subtract 3 months from that?
thanks!
 
nycdon said:
is there an easy way to get the first day of current month - also
need to then subtract 3 months from that?
thanks!
Click to expand...

FirstOfThisMonth: DateSerial(Year(Date()), Month(Date()), 1)

ThreeMonthsAgo: DateSerial(Year(Date()), Month(Date())-3, 1)
 
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

Excel Message box with days of month & date. 1
Excel Monthly Spread sheet. 12
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Excel Vba to change displayed year automatically. 14
Excel Date of first friday every month 3
Bargain 30GB for £10 a month on a 1 month contract. 4
Date field format 3
How to subtract a number from a Mergefield? 0

Back
Top