Hi,
I'm currently using the (probably overly complex) formula to return the week number of the month so that I can add up money taken in that week. (the reference to the weekly report tab is just a cell with the month in it)
=IF(A2="","",IF(MONTH(A2) < MONTH(DATEVALUE('Weekly Report'!$C$3&"...