VBA To return week number? MrFredPret Nov 16th 2015 Re: VBA To return week number? Quote from vaasha;641275 SimplyFormat(Date, "ww") So simple Thank you vaasha