formula week

  1. pedie

    Do we have a Formula to get the week from the date? :)

    Suppose in cell 1 i have a date 9/8/2010, can the formula show me whether it is in week1, 2,3,4 respectively? Thanks for helping! Pedie;) I have =WEEKNUM(H45,2) which return week number for whole year...But I am looking for like week1 of sept for instance. thanks again!

Some videos you may like

This Week's Hot Topics