How to get the Excel to calculate the exact date from a given date
Here are 2 options:
For data in Row_2
1) I2: =EDATE(G2,H2)
Note: the EDATE function is part of the Analysis ToolPak add-in. You might
need to enable or install it. (<Tools<Add-ins...etc)
2) I2: =DATE(YEAR(G2),MONTH(G2)+H2,DAY(G2))
For days remaining:
J2: I2-F2
(formatted as a number)
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
"Phil" wrote:
Hello,
I have five columns shown below, with sample values after the colon
(Col F) Today's Date: 04-28-06 {this will be using the =TODAY() function}
(Col G) Contract Date Signed: 03-28-06
(Col H) Duration (Months): 12
(Col I) Expiration Date: 03-28-07*
(Col J) Days Remaining in Contract: 334*
* these are hypothetical, they are not correct
If the user puts 12 in column H, for the duration, the result will be
03-28-07.
But what if someone puts something other than 12, like 8, 6, 7, or 13? I
need someway to be able to get Excel to tell me the EXACT day that the
contract will expire, AND how many days are left in the contract. BTW, the
user will ALWAYS be entering whole numbers, not decimals, eg. 6.5 months.
Thanks in advance for your responses.
Phil.
|