Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculate future date
I need to calculate a future date. Sohow do I calculate the final payment
date? Weeks or Months? Total $3,000.00 Payments $34.00 Begin Date 4/5/05 End Date ? thanks in advance |
#2
|
|||
|
|||
On Fri, 8 Jul 2005 10:59:01 -0700, "kevrgallagher"
wrote: I need to calculate a future date. Sohow do I calculate the final payment date? Weeks or Months? Total $3,000.00 Payments $34.00 Begin Date 4/5/05 End Date ? thanks in advance Are you the payor or the lender? If you are the payor, then you need to calculate it the same as your lender. If you are the lender, then you can decide. To add dates, understand that Excel stores dates as serial numbers with 1 = "1 Jan 1900" or "2 Jan 1904" depending on the date system selected. So to add weeks: FutureDate = StartDate + NumberOfWeeks * 7 To add months: Futuredate = DATE(YEAR(StartDate), MONTH(StartDate)+ NumberOfMonths, DAY(StartDate)). In adding months, since all months do not have the same number of days, you may get unexpected results if DAY(StartDate) is greater than 28. --ron |
#3
|
|||
|
|||
If the due date is in 30 day, and the begin date is in A1:
=A1+30 ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "kevrgallagher" wrote in message ... I need to calculate a future date. Sohow do I calculate the final payment date? Weeks or Months? Total $3,000.00 Payments $34.00 Begin Date 4/5/05 End Date ? thanks in advance |
#4
|
|||
|
|||
Are your payments weekly or monthly? Is interest being charged?
Regardless, assume the Total is in a1, Payments in a2 and Begin Date in a3 First, you need to calculate the number of periods. If no interest is being charged, the term is a1/a2. If interest is involved, you calculate the number of periods with =nper(rate,a2,-a1). Assume this result is in a4. If payments are weekly, your end date is a3+a4*7 If payments are monthly, your end date is =date(year(a3),month(a3)+a4,day(a3)) -- Regards, Fred Please reply to newsgroup, not e-mail "kevrgallagher" wrote in message ... I need to calculate a future date. Sohow do I calculate the final payment date? Weeks or Months? Total $3,000.00 Payments $34.00 Begin Date 4/5/05 End Date ? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Calculate a future or past date in Excel? | Excel Discussion (Misc queries) | |||
calculate anniversary of date after specified date | Excel Worksheet Functions | |||
calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Calculate sequential value for future date | Excel Worksheet Functions |