If cell C4 contains 3/14/08 then in another cell =TEXT(C4-19,"mm/dd/yy - ")
& TEXT(C4-6,"mm/dd/yy") will produce 02/24/08 - 03/08/08

Tyro

"Surveyor" wrote in message
...
To define a payroll bi-weekly payperiod. ie. 02/24/08 - 03/08/08
Want to enter one date in cell C4. say 03/14/08
I know that the formula =C4-19 will get the start date 02/24/08.
I know that the formula =C4-6 will get the ending date 03/08/08.

How do you format the two expressions together (with a dashed between)
into
a single cell: 02/24/08 - 03/01/08 ?

Thanks