Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Calculate No Of Months Seperate For Two Different Years

Dear All

Am Tana, new to this forum. I need help for making excel formula for the following

A1 = 02-Oct-11
A2 = 01-Apr-12

I want to calculate number of months & days seperate for year 2011 & year 2012.

Hope you people help me in this regard.

Thanking you in advance

Tana.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i calculate age in term of years, months, days shan Excel Worksheet Functions 1 March 15th 06 10:21 AM
Calculate Age in Years and Months? Grd New Users to Excel 1 February 15th 06 05:07 PM
how to calculate years, months by using one formula srinivasa rao Charts and Charting in Excel 2 April 15th 05 08:28 AM
calculate date differences in years and months Joyce Excel Worksheet Functions 1 March 14th 05 05:18 PM
Calculate months and years Ned Ludd Excel Discussion (Misc queries) 5 December 10th 04 01:57 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"