Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Calculating a date with term

I am needing to calculate a future or present date from a date 1 and term
e.g. I have an entry date 1 (June 2008) and a term (5.16) and need to
calculate the date 5.16 before or after my date 1
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Calculating a date with term

5.16 days, 5.16 weeks, 5.16 months (in which case how do you define a
month?), 5.16 years, ... or what ?
--
David Biddulph

"Dubesta" wrote in message
...
I am needing to calculate a future or present date from a date 1 and term
e.g. I have an entry date 1 (June 2008) and a term (5.16) and need to
calculate the date 5.16 before or after my date 1



Reply
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
Calculating a percentage of days in a term Terri R Excel Discussion (Misc queries) 1 June 12th 06 11:58 PM
Formula for If Term is on Certain Date then Count Krisjhn Excel Worksheet Functions 3 August 30th 05 07:57 PM
calculating term of financial transaction bookman3 Excel Worksheet Functions 4 July 26th 05 05:25 AM
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM


All times are GMT +1. The time now is 07:43 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"