I am trying to enter a line item in an invoice that states the Week ending date like this "HOURS WE" then states the date on the invoice (F2 which is 1/26/14) minus 7 days. So far, I have gotten the formula to calculate formula but it includes the date as a number AND as date and does not subtract the seven days. (see below)
HOURS WE 41658 01/26/14
How do I remove the number portion and subtract 7 days so it says "
HOURS WE 01/19/14" if my formula is
=" HOURS WE "&IF($F$2="","",$F$2-7)&TEXT(F2," MM/DD/YY")