I'm not sure how that would work? I basically need to know how many days are
in a date range so the 13th-30th is an easy example. It's always on a 30 day
period. I would use it to calculate a "prorated" cost so if a person's
billing date is the 30th and they change something on the 13th I would need
to know the amount of days between the 13th and the 30th (including the 13th).

So to use my example from earlier if the individuals billing date is the 8th
and they change something on the 23rd of the month before I want the sheet to
tell me that there is 16 days in between (that includes the 23rd).

While I've seen this one: =IF(B7A7,DATEDIF(A7,B7,"d"),DATEDIF(B7,A7,"d"))

That uses a normal calendar to do the calculations (30, 31, etc. months) and
I need it calculated on a 30 day basis always.

Thanks for the help, but I'm still stuck.

"Sheeloo" wrote:

Not sure of your requirement
but if first number is in A1 and second in B1 (with A1 always higher than B1)
Use this in C1
=A1-B1+1

-------------------------------------
Pl. click ''Yes'' if this was helpful...



"James Dasher" wrote:

I want to be able to calculate the days between two "dates" however I need it
on a 30 day system. It doesn't run on a true calendar, but always on 30 days.
So essentially between two 1-30 sets I need the amount. I want to include the
first number.

So if I put down in the first cell "23" and the second cell say "8" I need
the total to be 16

Any suggestions?