Split a figure by a given number of months in a finanacial years

**SKirkaldy** · 09-10-2013, 07:07 AM

Hi, please help, really not sure how to calculate this formula.

If I was given some money on 1/10/2013 of £240 and need to divide this over a 12 month period over 2 years

2013 2014
£60 £180

Any ideas???

S-J

**ramananhrm** · 09-10-2013, 07:28 AM

I have tried with the helper columns.

**SKirkaldy** · 09-10-2013, 09:09 AM

Hi,

Do apologise, but please could you explain in more detail the workings out.

I have also now attached a copy of my data with the fields, could you make it work with this?

S-J

**ramananhrm** · 09-11-2013, 01:03 AM

Please modify the dates & test the file as you require (In Green)

Split a figure by a given number of months in a finanacial years

LinkBack

Thread Tools

Rate This Thread

Display

Split a figure by a given number of months in a finanacial years

Re: Split a figure by a given number of months in a finanacial years

Re: Split a figure by a given number of months in a finanacial years

Re: Split a figure by a given number of months in a finanacial years

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Age based on DOB; Accounts for leap years. Years old if >2, Months if <2 years old.

[SOLVED] Number of years, months, days between two dates.

[SOLVED] Number of years/months/days between 2 dates

[SOLVED] how do I convert a number to number of years, months and days

[SOLVED] Converting number of days to years and months

Bookmarks

Bookmarks

Posting Permissions