Bi-weekly date formatting

S

Surveyor

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
 
T

Tyro

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
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top