 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Calculating Dates
Hi, I need to construct a spreadsheet that will tell me how many days have elapsed from x to the present. An example would be if I put in A1 10/10/07 Then in B1 you sould see 30 days (or however many years) A2 4/3/04 B2 3.5 years (or whatever) Is there anyway to do that so it updates for on a daily basis? Thanks a lot. The =NOW() function gives the current date so... Type in B2 =INT(NOW()-A1) and make sure that B2 is formatted as a number, not a date. The =INT function is not strictly necessary. It converts the date into an integer so you don't have a decimal fraction of a day. Copy this formula into B2 for your 2nd example. If automatic recalculation is not turned on, press SHFT-F9 > Hi, > [quoted text clipped - 18 lines] > > Thanks a lot. >The =NOW() function gives the current date so... > [quoted text clipped - 7 lines] >Copy this formula into B2 for your 2nd example. >If automatic recalculation is not turned on, press SHFT-F9 =today()-a1 format as general or =today()-a1+1 (if you want to include the end date) For the other stuff, look at Chip Pearson's notes for =DateDif(): http://www.cpearson.com/excel/datedif.aspx >> Hi, >> [quoted text clipped - 18 lines] >> >> Thanks a lot. Thanks, guys. Both ways worked. =today()-a1 format as general or =today()-a1+1 (if you want to include the end date) For the other stuff, look at Chip Pearson's notes for =DateDif(): http://www.cpearson.com/excel/datedif.aspx > Hi, > [quoted text clipped - 18 lines] > > Thanks a lot.  SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.