Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DonnaRy
 
Posts: n/a
Default Calculate a Date In Excel

I am trying to calculate contract expiration dates based on the contract
start date plus a given number of calendar days. Is this possible?
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

=A1+n

where A1 is the start date, n is the given number of days.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DonnaRy" wrote in message
...
I am trying to calculate contract expiration dates based on the contract
start date plus a given number of calendar days. Is this possible?



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
how can I calculate chronological age in excel Mike New Excel Discussion (Misc queries) 7 April 25th 23 11:45 AM
Despite formatting a column in Excel 2002 worksheet as Short Date. Pete Whalley Excel Discussion (Misc queries) 2 February 7th 05 06:17 PM
In Excel 2003, entering date without slashes, the date is incorre. sj Excel Discussion (Misc queries) 6 January 6th 05 03:07 PM
Excel: Is there a way to calculate the date as week of month? debra adams Excel Discussion (Misc queries) 2 January 3rd 05 09:39 PM
Excel Date in uppercase Steve J. Vaughan Excel Worksheet Functions 9 December 15th 04 03:25 PM


All times are GMT +1. The time now is 10:01 AM.

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

About Us

"It's about Microsoft Excel"