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 :
[VBA] =INT(DAY(B4)/7+0.99)[/VBA]
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 ...