close

Hi I am Tanuja i need to know what week is it in a month not in a year is it
possible

Assuming that the date is in A1, and week 1 starts on the 1st (not 1st
Sun/Mon say), then

=INT(DAY(A1)/7) 1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Tanuja Kandulaquot; lt;Tanuja gt; wrote in message
...
gt; Hi I am Tanuja i need to know what week is it in a month not in a year is
it
gt; possible

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()