Solved

Excel Formula

Posted on 2014-07-23
4
245 Views
Last Modified: 2014-07-23
Hi Experts,

Need your help on -
to get total number of month & date between two dates.
Say Start date is 15 Jan 2014 & end date is 26 Jul 2014
I need some thing like this 6.10 month.days

Thanks
0
Comment
Question by:itjockey
  • 2
4 Comments
 
LVL 19

Assisted Solution

by:helpfinder
helpfinder earned 250 total points
ID: 40214123
check this sample if it is as you want to be ...
It calculates also option that you insert date from different years
sample.xlsx
0
 
LVL 23

Accepted Solution

by:
NBVC earned 250 total points
ID: 40214134
Perhaps:

=DATEDIF(F1,G1,"m")&"."&(DATEDIF(F1,G1,"md")-1)

where F1, G1 contain the dates
0
 
LVL 8

Author Comment

by:itjockey
ID: 40214223
Sure I will try and let you know , purpose is want to calculate rate of return between two dates ...monthly basis I.e. if I had earned 53% return between these two dates then what is my monthly return.
I am headed toward right way? Pls suggest.

Travelling +>test your formula as soon as reach home.

Thanks
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 40215447
Awsome
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
First Blank Cell in a range 7 35
SUMIFS with a criteria that could be in multiple rows 21 35
Excel Automation VBA 19 37
min values in series 13 0
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now