Hi Folks,

Can anyone suggest a formula that will return the current week number in a month based on today's date AND it's adherance to the number of reporting periods in the month? For example, the attached file shows the number of reporting periods (number of Friday's) in ever month for 2013.

I need a formula that works out which reporting week number today's date falls into. So result should be 4 for today's date (23-Jan-13) and 1 for any date after Friday (25-Jan-13).


Reporting Period.xlsx