Trying to count the number of paydays

[Ltat42a]

Hi All,
how can I write a formula to calculate the number of paydays I have left in my current job?

Today's date - 06/26
My next payday is 07/03
My last payday will be 12/18/09

I get paid every two weeks.

any ideas?

Thanx

[NBVC]

Try:

=(B1-A1)/14+1

where A1 houses next pay date and B1 houses last pay date.

[Ltat42a]

Try:

=(B1-A1)/14+1

where A1 houses next pay date and B1 houses last pay date.

Do you know how to have it calculate based on today's date?

[NBVC]

Perhaps?

=INT((B1-(TODAY()-WEEKDAY(TODAY(),3)+3))/14+1)

where B1 houses your last pay date