WEEK in MONTH

[PaSha]

hy again me and again asking questions...

i opened a new post, becouse this is a simple question, but i thought, when someone else was having the same trouble, maybe he would find this post on the internet, and maybe also a solution ...

so the problem is this ... i need to calculate which week in month it is...

i have made some functions by myself but they didn't run like they should... so i googled it and found this function which was similar to myn and i thought it works... but today i realised it doesn't... so the function look like this :

 =INT(DAY(B4)/7+0.99)

and like it says: for the today it should bring me that it is the 4th week in month and 3th day in week!! but it results this : 3th week & 3nd day...


so why is this so ... how can i get this week number in a month ...

i need to know this, becouse i have some if statements which then link to specific workbooks when such week number is today...


so if anyone knows... please help...

i know maybe stupid question... but that's why i posted it... maybe someone else needs this also, maybe not today but in the future ...

thanks again ...