Help with formula

[wuha]

I need a forumla that will prorate days. for example. It needs t
calculate a number which could be 18 then subtract 30 from it to figur
out how many days from the 18th until the 30th THen multiply by -1 t
make that a positive number THEN ADD the prorated date which would b
for example 7th day. So answer would be 18th of this month until 7th o
next month would = 19 days, i have played a formula that got it workin
but need to find a way that if the number is 18 it would say 0 or i
the number were to be HIGHER then 18 or the original number it woul
not need to -30 it would just think from the 18th to the 19th is on
day. Can anyone help? thanks

 

[Frank Kabel]

Hi
not really sure why you're trying to use such a complicated algorithmn.
Could you give an example with some more values and what your objective
is?

 

[CLR]

The actual number of days between the 18th of one month and the 7th of the
next month can of course vary, depending on which months you're dealing
with. I would suggest you build your project using actual dates as your
base, rather than just day numbers. Excel sees each date as a unique number
and remembers how many days are in each month, and will do the math
accordingly.

hth
Vaya con Dios,
Chuck, CABGx3

 

[wuha]

It's for a project. Every month cycle is done by 30 days. it's the wa
it's calulated. I just need it to do it by 30. I can't seem to have i
be smart enough to think 18-19 is one day but i can get it to work fro
18-7th of next month (in a 30 day period) any idea's on forumlas
Thanks

 

[CLR]

Maybe something like this in C1.............
Assuming your numbers are in A1 and B1..........

=IF(B1>A1,B1-A1,(B1+30)-A1)

Vaya con Dios,
Chuck, CABGx3