Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculate the last day of the month... (2000)

    Have a dinamic variable Month_Var and it can assuming value similar "01", "07", "12" ... ecc (are the number of the month)
    How to return in var Last_Day the last day of Month_Var ????

    Note:
    if is possible calculate the last day of febrary based other var = Year_Current ...

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Calculate the last day of the month... (2000)

    <code>Last_Day = DateSerial(Year_Current, Month_Var + 1, 0)</code>

    should do it.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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