MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date Functions --> Week of .....

Posted by SJC on November 29, 2000 1:50 PM

This is what I'm trying to do:
Date Week of....
11/28/00 mm/dd/yy (where mm/dd/yy is the date of the Monday of the week containing 11/28/00)

Does anyone know if there is a function or a formula that will give me mm/dd/yy?

Posted by Neil on November 29, 2000 6:56 PM

Try =A1-WEEKDAY(A1)+2 where A1 is the date of the Monday you want to find