Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Date Formula (2K)

    I want to have a formula return the first day of last month. =date(year(now()),month(now())-1,1) doesn't work in January. This should be easy but I'm currently experiencing some sort of brain fart.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Formula (2K)

    That formula will work OK in January too - the DATE function accepts 0 as value for the month, and interprets it as the last month of the previous year. Similarly, if you specify 0 for the day, you get the last day of the previous month.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •