Contract Value Formula

Gizmo28

New Member

Join Date: Apr 2010

Posts: 1

14th Apr 2010

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

« Nested IF(OR(AND) Statement with Two AND Conditions | General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using contract start/end dates and calculating annual contract day	Redcon	Microsoft Excel Misc	3	19th Apr 2008 12:03 AM
entering date, formula for continuing date to contract terms	=?Utf-8?B?TGlzYQ==?=	Microsoft Excel Programming	1	30th Oct 2006 02:15 PM
Do you have a contract for a DJ?	=?Utf-8?B?TGFuZGU1MTg=?=	Microsoft Word Document Management	1	12th Feb 2006 03:43 AM
Contract or no contract?	=?Utf-8?B?QmV2ZXJseS1UZXhhcw==?=	Microsoft Frontpage	9	9th Mar 2005 06:10 AM
Contract	Dan K.	Microsoft Word Document Management	2	17th Sep 2003 02:55 AM