« how often do you... | Main | Biow Tutorial: Hanyu... »

18
May · Tue 2010

Biow Tutorial: How to Find the Number of Days, Months, and Years Between Two Dates in MS Excel Tutorial



Question: How to Find the Number of Days, Months, and Years Between Two Dates in MS Excel?

Answer: Assuming your date1 is in cell A1 and date2 in cell A2, type the following in the B1 cell:

=YEAR(A2)-YEAR(A1)-IF(OR(MONTH(A2)<MONTH(A1),AND(MONTH(A2)=MONTH(A1), DAY(A2)<DAY(A1))),1,0)&" years, "&MONTH(A2)-MONTH(A1)+IF(AND(MONTH(A2) <=MONTH(A1),DAY(A2)<DAY(A1)),11,IF(AND(MONTH(A2)<MONTH(A1),DAY(A2) >=DAY(A1)),12,IF(AND(MONTH(A2)>MONTH(A1),DAY(A2)<DAY(A1)),-1)))&" months, " &A2-DATE(YEAR(A2),MONTH(A2)-IF(DAY(A2)<DAY(A1),1,0),DAY(A1))&" days"


See also:

  1. Set header and footer as an Excel template Tutorial
  2. Remove duplicate data or records, create list of unique data or records in Excel 2003
  3. Tutorial: Black and White with some parts colored using Photoshop CS3
  4. Tutorial: Adding copyright watermark to your images using Photoshop
  5. Biow Tutorial: Animate series of images with Photoshop CS3
  6. Tutorial: Reflection effect in PS
  7. Reference: Photoshop Magnifying Glass Tutorial
  8. Reference: Add Speech Balloons and Text Bubbles to Your Photos in Photoshop or Elements Tutorial



(2010-05-18 10:52:13 SGT) [biow's tutorial] Permalink


Comments:

Post a Comment:

Comments are closed for this entry.

« how often do you... | Main | Biow Tutorial: Hanyu... »



Most popular blog postings in Biow's world:

  1. 2010 O-Levels cut off point to JC (Junior College) in Singapore
  2. Sengkang Swimming Complex
  3. Recipe: Honey Vanilla Pound Cake Recipe by Ina Garten of Barefoot Contessa
  4. Fisheye effect with Photoshop CS 3
  5. Digital photography tutorial for Nikon D40 DSLR
  6. Canon DSLR Tutorial Guide for Beginners
  7. Watch Korean Dramas online for FREE.. Feeding your drama addiction..
  8. more links to watch korean dramas online free with subs
  9. Korean Drama: The Legend (Tae Wang Sa Shin Gi) by Bae Yong Joon Episode Guide
  10. resignation letter for less than tender notice sample


Featured articles in Biow's world:

  1. Singapore Maths P1 Worksheet Online Generator - Problem Sums
  2. Singapore Maths P2 Worksheet
  3. Canon DSLR Tutorial Guide for Beginners
  4. Cake Decoration 101 - How to cream / frost a cake
  5. Cake Decoration 101 - Shell Piping
  6. Freezing Expressed Breastmilk (EBM) in 3 steps
  7. Another way to freeze Expressed Breastmilk (EBM)
  8. Storing of Expressed Breastmilk (EBM)
  9. How Breastfeeding Benefits Add Up
  10. Do not use glass bottle to freeze your precious breastmilk


Search

Sponsored Links

Categories

Tags

art_n_craft
birthdays
career
cny
comic
cut-off
education
family
flash
image_tools
k-drama
maths
movies
mr_clever
mr_earnest
mr_steady
ms_chatterbox
ms_excel
office2003
p1
p2
p3
pet
school
science
singapore
syllabus
travel
tutorial
word_of_mouth
Links

Comments
Recently Commented

Navigation

Front Page
Weblog
TagsIndex
Privacy Policy
Login
Decals





rss feed for in Biow's World..

powered by Roller