Hello and welcome to the board

This formula appears to work. It assumes that the start date is in cell A2. In order to use this the Analysis Toolpak must be installed. You can do this by clicking Tools, Add-ins and then checking the Analysis Toolpak addin.

=IF(WEEKDAY(A2)=6,INT((EOMONTH(A2,0)-A2)/7)+1,INT((EOMONTH(A2,0)-A2)/7))[/i]

HTH,

Dan

## Like this thread? Share it with others