Results 1 to 20 of 21

Thread: WEEK in MONTH

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 11-21-2007, 10:16 AM #7
    PaSha
    PaSha is offline
    VBAX Contributor PaSha's Avatar
    Joined
    Nov 2007
    Location
    Slovenia
    Posts
    104
    Location

    Exclamation Sloved

    Quote Originally Posted by xld
    Could it be that you need Continental separators

    =ROUNDDOWN((DAY(B4)+WEEKDAY(B4-DAY(B4)+1)+5)/7;0)
    hey guys.. sorry for the late answer... but yesterday i went to sleep...

    it works ... this formula works, i wwas just falling to sleep, that i didn't saw that ( mistake ...

    and now it works ... thanks again xld ... and also others who replayed to my post, but i didn't trayed other formulas, becouse this was doing fine, so can't tell if other work... i can just say : case SOLVED ...
    Last edited by Aussiebear; 03-09-2025 at 01:24 PM.
    I like to help others... but sometimes i also need help ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules