Date Formula to Return Week Number in Current Month based on Reporting Period

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

Hi jeversf,

This is probably a clunkier solution than you might have hoped for, but in the absence of any other solutions/suggestions, it may help.

Thanks for that Brendan, I ended up using a similar workaround with a helper worksheet.