Try this for c1:
=ROUNDDOWN((B1-TODAY())/14,0)

Regards,
Fred

"Judoman" wrote in message
...
I'm trying to make up a budget for my family. I'd like to be able to
enter in the amount of an upcoming bill (a1), the due-date of an
upcoming bill (b1), then somehow have Excel calculate how many pay-
days I will get before that date (c1) then I will use a formula =a1/c1
to tell me how much money I need to put aside from each of my upcoming
paydays.

Is this possible, to get such a formula for cell c1? I get paid on
Friday morning every second week (eg. next one is Friday the 12th).

thanks very much!