Counting the amount of paydays between two dates

[Prospero]

Hello

I am currently unemployed but I have just created a spreadsheet i
Excel 97 to help me to work out some savings when I get a new job(!)

In A1 I have a start date (01/11/2004)
In A2 I have an end date (01/11/2005)

Is there a formula that will tell me how many paydays there will b
between the two dates, if I specify the date of the first payday in
for example, cell B1

 

[Jim May]

Sample only:
In B1 - enter say 14 (If paid Bi-Weekly) or enter 7 (If Paid Weekly)
In C1 - enter =INT((A2-A1)/B1)
HTH

 

[Hank Scorpio]

I am currently unemployed but I have just created a spreadsheet in
Excel 97 to help me to work out some savings when I get a new job(!)

In A1 I have a start date (01/11/2004)
In A2 I have an end date (01/11/2005)

Is there a formula that will tell me how many paydays there will be
between the two dates, if I specify the date of the first payday in,
for example, cell B1?

Why not just put the first pay date in A1?

However, working from the example that you gave, bear in mind that it
will ALSO depend on how often you get paid. Let's say that you put the
number of days between payments in B2, directly under your first pay
date. The following formula will do it for you:

=INT((A2-B1)/B2)+1

Good luck with finding a job.