VBA To return week number? MrFredPret November 16, 2015 at 8:59 AM Re: VBA To return week number? Quote from vaasha;641275 SimplyFormat(Date, "ww") So simple Thank you vaasha