Bi-weekly date formatting
 

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

Bi-weekly date formatting
 

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

Bi-weekly date formatting
 

If you mean entering any date from the end of the previous pay period up to,
but not including, the last day of the present pay period then try:

=TEXT((C4-7)-MOD(C4-7,14)-6,"mm/dd/yy")&" -
"&TEXT((C4-7)-MOD(C4-7,14)+7,"mm/dd/yy")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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