Bi-weekly date formatting

  • Thread starter Thread starter Surveyor
  • Start date Start date
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
 
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
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top