How to calculate year, month and day between 2 cells in MS Excel 2010

Sometimes we need to calculate year, month and day between 2 cells in  Microsoft Excel.
For example, You have an employees database in excel that record the date they joined the company and then you want to know "how long each employee has worked for the company until now?"

In the such above case, I do the following in Microsoft Excel 2010:

  • I Input the "signed date" in cell C3 after "No" in cell C1 and "Full Name" in cell C2.
  • Make sure to assign "Date" as Cell Format for Cell C3.
  • I input =NOW() in Cell C4 and this will show the current date.
  • And the calculation begin in cell C5.
  • In cell C5, I put formula like this: =DATEDIF(C3,C4,"y") & " years, " & DATEDIF(C3,C4,"ym") & " months, " & DATEDIF(C3,C4,"md") & " days"
  • And the result of the above formula is like this: 19 years, 3 months, 11 days.


If you do not want to show the "day", just cut the last part of the formula (& DATEDIF(C3,C4,"md") & " days").

So now, you know how to calculate year, month and day between 2 cells in MS Excel 2010.

Do you have other formula to calculate the same above case?
Please share on the comment below.
Thank You

Comments

Post a Comment

Popular posts from this blog

How to delete saved Username/Password when you browse password protected folder on network in win 7?

I have Bufallo data link station 1 terabyte attached to my LAN. I have created some shared folders and each of shared folder has user access restriction only for certain user. One day I have to change my admin password. Open Command Prompt (Start > Search "cmd" > Enter) Enter the line: rundll32.exe keymgr.dll, KRShowKeyMgr When the window comes up you should be able to manage stored keys.
Read more

Installing NGINX, PHP and MYSQL on Linux Mint 9

For Development purposes, I try to install NGINX, PHP and MYSQL on My Linux Mint 9. Following instruction on HowToForge Site , bellow are all steps I made to install NGINX, PHP and MYSQL: (All commands, need root privilege, and run from terminal) 1.  run "apt-get install mysql-server mysql-client" to install MySql server and client. And you will be asked to provide root password, at the end of this process. 2. run "apt-get install nginx" to install Nginx 3. run "/etc/init.d/nginx start" to start Nginx 4. go to your browser and open http://localhost, then you will see "Welcome to nginx!" page. It means that nginx is running successfully. 5. run "update-rc.d nginx defaults" to make nginx start at boot time. 6. run "apt-get install php5-cgi php5-mysql php5-curl php5-gd php5-idn php-pear php5-imagick php5-imap php5-mcrypt php5-memcache php5-mhash php5-ming php5-pspell php5-recode php5-snmp php5-sqlite php5-tidy php5-xmlrpc php5
Read more

Cpanel Default Web Page

When you setup a new cpanel server and want to test the apche service then you try to call the IP address like http://74.xxx.xx.xx. to see if its working. You will see the default webpage defaultwebpage.cgi. This is the standard system on cpanel. The defaultwebpage.cgi actualy is the result of redirection of index.html in /usr/local/apache/htdocs/index.html. The defaultwebpage.cgi itself is placed in /usr/local/cpanel/cgi-sys/defaultwebpage.cgi. To modify this defaultwebpage, try this 2 simple options: 1. Edit /usr/local/apache/htdocs/index.html. and change the meta http redirection. Index.html consist this simple html script: META HTTP-EQUIV="refresh" CONTENT="0;URL=/cgi-sys/defaultwebpage.cgi You can change the value in URL=/cgi-sys/defaultwebpage.cgi to URL=/another/page. 2. Or you can edit /usr/local/apache/htdocs/index.html to what ever you like. Wana try....?
Read more