I want to create a formula that will get the start of week - end of week for dates.
This is the formula I have so far:
it works partially because it shows them as numbers. I need to show them as mm/dd/yy![]()
=B2-WEEKDAY(B2,1)+1 & "-" & B2-WEEKDAY(B2,1)+8
Here is an example:
07/10/10
Changes to:
07/08/10 - 07/15/10
Bookmarks