from date return week date range
I have a date in a cell. How can I return the value of the monday before and
the friday after that date?
Example:
input: 01/25/2007 (in this case a thursday)
output: 01/22/2007 - 01/26/2007 (monday - friday of above week)
Thanks in advance for any help!
--
ERahn
|