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
