LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Seldum
 
Posts: n/a
Default A simple date calculation question.


Heres my problem. I want to calculate the end date of a contract.

I have the start date fx. 30.05.06 (date field) and I know the contract
runs for a periode of fx. 40 month (not a date field) - how do I get the
end date?

I have looked in the forum and coulden't find an answer. The dates can
variate at the beginning date fx. 10.05.06 but it will always end at
the date when the contract runs out fx. 10.10.06 if the periode = 5
(month).

Is this possible to calculate?

Thanks.


--
Seldum
------------------------------------------------------------------------
Seldum's Profile: http://www.excelforum.com/member.php...o&userid=35793
View this thread: http://www.excelforum.com/showthread...hreadid=555594

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question about having the date autofill for schedule sheets VegasBurger Excel Worksheet Functions 5 June 16th 06 06:58 PM
Date calculation MIchel Khennafi Excel Worksheet Functions 3 April 27th 06 07:35 PM
Date calculation OCD Cindy Excel Worksheet Functions 3 April 5th 06 06:06 PM
Date Comparison Calculation PAR Excel Worksheet Functions 2 March 22nd 06 05:18 PM
Calculation based on date Jack Excel Discussion (Misc queries) 3 March 22nd 06 08:17 AM


All times are GMT +1. The time now is 05:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"