M
mrsteveo
Hi all,
I'm not an Excel expert but I am wondering how I might accomplish the
following.
I work at an ISP and lets assume a customer wants our 256 x 256
package which is $31.00 month.
Obviously, if they sign up on say the 10th of the month, our billing
system bills them the 10th - End of Month + 1 FULL MONTH.
I'm wondering how I can put say $31.00 + $22.95 (phone service charge
per month) into a formula and have it figure out the pro-rate
depending on which date I use + the 1 full month? Make sense?
I need a formula to calculate pro-rate (so let's use the 10th) 10th
through end of the month + 1 full month and have different figures/
sums depending where in the cycle it falls.
I hope this makes sense. Let me know if I need to clarify and if you
have any ideas on how to accomplish this I am all ears.
Kind regards and many thanks in advance,
Steve Ryan
I'm not an Excel expert but I am wondering how I might accomplish the
following.
I work at an ISP and lets assume a customer wants our 256 x 256
package which is $31.00 month.
Obviously, if they sign up on say the 10th of the month, our billing
system bills them the 10th - End of Month + 1 FULL MONTH.
I'm wondering how I can put say $31.00 + $22.95 (phone service charge
per month) into a formula and have it figure out the pro-rate
depending on which date I use + the 1 full month? Make sense?
I need a formula to calculate pro-rate (so let's use the 10th) 10th
through end of the month + 1 full month and have different figures/
sums depending where in the cycle it falls.
I hope this makes sense. Let me know if I need to clarify and if you
have any ideas on how to accomplish this I am all ears.
Kind regards and many thanks in advance,
Steve Ryan