What's New? | Contact Us

About Us | Site Map     

Home
Access Tips
Excel Tips
Microsoft Office Tips
PowerPoint Tips
Word Tips

 

Weekly Picks

Cool Websites
Publications
Key Trends
Useful Resources
Tech Tips
 
Picks Archives
 
 

Bookmark and Share

Tech Tip of the Week: August 30 - September 5, 2015

Calculate the Days, Months or Years between Dates in Excel

Use the DatedIf function to calculate the interval between dates in Excel. Here's how:

bullet

Enter the function into a cell

=DATEDIF ( start_date , end_date, unit )

bullet

For example, to calculate the number of months between two dates, if the start date is in cell D2 and the end date is in cell E2 you could enter this formula into cell F2:

To learn more about this function, go to to the Microsoft website or watch a YouTube video. This tip works in Excel 2007 and 2010, as well as earlier versions.
 

View all Access Tech Tips

View an alphabetical listing of Access Tech Tips

View all Excel Tech Tips

View an alphabetical listing of Excel Tech Tips

View all Office Tech Tips

View an alphabetical listing of Office Tech Tips

View all PowerPoint Tech Tips

View an alphabetical listing of PowerPoint Tech Tips

View all Word Tech Tips

View an alphabetical listing of Word Tech Tips

   

"Man's mind, once stretched by a new idea, never regains its original dimensions." Oliver Wendell Holmes, Jr. View Past Quotes

frank@createthefuture.com susan@createthefuture.com

2015 Creative Information Systems 

 In Association with Amazon.com

Revised: September 1, 2015