Contract Value Formula

G

Gizmo28

Joined
Apr 14, 2010
Messages
1
Reaction score
0
Hi,


I am trying to calculate a contract value that is spread over 3 years into its respective years. For example a contract value of £52000 start from the 01/05/2010 untill the 31/04/2012. I need to calculate how much of that contract will book into 2010, 2011 and 2012.

Can anyone help please?

Regards Gizmo28
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allocate an income payment over a date range (tax years) 7
help with Sum in between dates 9
Find then highlight in yellow 6
Please help for FV and XIRR function. 3
Sorting Columns with a Formula 1
Future Value Array Formula 1
Sum amount of days in another coloumn 8
Problems with an array formula using "sum, if, or & vlookup" 1

Top