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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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