Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Last day of month (97-2)

    Can anyone give me the function for finding the last day (date) of the month ? I have to make sure my users are entering the last day (date) of the month for any given month.
    Thanks

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Columbus, Ohio, USA
    Posts
    286
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Last day of month (97-2)

    Cathy: Try this:

    =DateSerial(Year(Date()),Month(Date())+1,0)

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Last day of month (97-2)

    Checkout <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=100995&fpart=1#P ost100995>this starred post</A>. You can easily modify it for any particular date rather than just today's date.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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