Jump to content
Sign in to follow this  
kanedsista

Newbie: Count number of months my records span

Recommended Posts

I would like to count the months my records span, so if my first record is on 11/02/07 and my second record is 11/05/07 it would return 3. I need it so I can work out the average monthly income by dividing the total income by the number of months that have passed since the first record.

So if my records spanned 3 months then it would divide the total income to date by 3 to get the monthly average.

But then again, at the end of the year I would need to reset this so it would count the income and the months from the first day of the new year/new tax year. So really it would have to be a month I specify, then it would find the records from that date, count the months to my last record and count the average income during this time.

I could just divide the total income by 12 but that wouldn't give me an accurate reading until the end of the year.

What sort of calculation would I need and is it possible to do this?

Share this post


Link to post
Share on other sites

I defo need a calc rather than a script. Just not sure how I should go about it.

Edited by Guest

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.