Need to calculate the number of days between two dates on a 30 day

[James Dasher]

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?

 

[Sheeloo]

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

 

[James Dasher]

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(B7>A7,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.

 

[Bernie Deitrick]

James,

=(YEAR(A2)-YEAR(A1))*360 +(MONTH(A2)-MONTH(A1))*30 + DAY(A2)-DAY(A1)

HTH,
Bernie
MS Excel MVP

 

[Sheeloo]

Use
=DAYS360(A1,B1) + 1
with start date in A1 and end date in B1

Days360 assumes that all months have 30 days...

 

[Ron Rosenfeld]

On Fri, 10 Apr 2009 16:53:01 -0700, James Dasher <James

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?

=days360(startDate,endDate)+1

With the dates in A1 and A2:

=DAYS360(A1,A2)+1

Take a look at HELP for this function to decide if you want to use the European
or the American method.
--ron