Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



calculation of date, month and year using excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 06-04-2011
Member
 
Join Date: Mar 2011
Posts: 56
calculation of date, month and year using excel
  

Hi, I am using Microsoft office Excel 2007 and i am using it with windows 7 system. I am preparing a work sheet for an institution as a part of my college assignment. I am having no idea on how to make calculations with the dates while working on Microsoft Excel. Is there any specific formula in excel to calculate total number of months and year between the two dates. Can anyone help me with the calculations. If there are any specific formula then please suggest me.

Reply With Quote
  #2  
Old 06-04-2011
Member
 
Join Date: Nov 2008
Posts: 1,514
Re: calculation of date, month and year using excel

To calculate number of days between the two dates is simple. Here are the simple steps with which you can calculate the days between the two dates. For example you want to calculate between two dates say 4 Jan 2011 to 6 April 2011.lets assume cell A1 contains 4/1/2011 and cell A2 contains 6/4/2011.then in cell A3 you can simply write A2-A1.the result that appear in the cell A3 might surprise you but don?t consider it as a wrong result. Go to format menu and choose ?cells?,click on the ?number? tab and select ?general? in the category list. Then you get the actual answer.
Reply With Quote
  #3  
Old 06-04-2011
Member
 
Join Date: Nov 2008
Posts: 1,221
Re: calculation of date, month and year using excel

You can calculate date, month as well as year in Microsoft Excel. Calculation of days is simple but calculating number of month and year is little bit complex but still you will find it easier. In Microsoft Excel there is a function called DATEDIF. The syntax for this function is DATEDIF(startdate,enddate,?interval?)and the formula to calculate number of months between two dates is DATEDIF(A1,A2,?m?).in the same way when you want to calculate number of years then the formula would be DATEDIF(A1,A2?y?)
Reply With Quote
  #4  
Old 06-04-2011
Member
 
Join Date: May 2008
Posts: 860
Re: calculation of date, month and year using excel

You can calculate the number of months and years using the formula DATEDIF(A1,A2,?m?) for months and DATEDIF(A1,A2?y?) for years. Assume that you want to calculate the number of months between 4 Jan 2011 to 6 April 2011.then in the function fx type DATEDIF(A1,A2,?m?).in the cell A1 enter 4/1/2011 and in cell A2 enter 6/4/2011.you will get the result in cell A3.Similarly you have to calculate for the year.
Reply With Quote
  #5  
Old 06-04-2011
Member
 
Join Date: May 2008
Posts: 979
Re: calculation of date, month and year using excel

Thank you all for your suggestions. For the reference I am now taking help of the book ?getting started with Microsoft Office Excel?.If I will have any doubt regarding Excel I will take help of this forum and post my question. I am still continuing with my project and I am very much thankful for your kind support.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "calculation of date, month and year using excel"
Thread Thread Starter Forum Replies Last Post
How to combine Month/Day/Year seperately in a different column in Microsoft Excel. $horizon$ Windows Software 2 13-01-2012 05:27 PM
MS Project calculation of end date kerryger Windows Software 1 15-04-2011 08:11 PM
Bash script for creating a new month and year Kohlmann Software Development 4 30-08-2010 09:09 PM
Calculation of business hours in Excel Jayden Windows Software 3 29-07-2009 08:15 AM
2003 excel calculation error titanpro Windows Software 2 20-07-2009 07:01 PM


All times are GMT +5.5. The time now is 10:58 AM.