Jump to content
Sign in to follow this  

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.