Help with formula

  • Thread starter Thread starter wuha
  • Start date Start date
W

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
 
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?
 
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
 
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
 
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
 
Back
Top