Calculate the number of months and days between two dates

Calculate the number of months and days between two dates

Hi,
Is there a formula where I can calculate the number of months and days between two dates.
eg start date 02 August 2010.
End Date 05 October 2010
equals - 1 month and 3 days
Thanks for your help

Anwsers to the Problem Calculate the number of months and days between two dates

Download Error Fixer for Free Now

Hi,
use the DATEDIF function:
A1: 02 August 2010
A2: 05 October 2010
Formula: =DATEDIF(A1,A2,"M")&" months / "&DATEDIF(A1,A2,"MD")&" days"
Result: 2 months / 3 days
DATEDIF() computes only complete months and days.
 
Regards,
Frank

If this post is the answer to your question, please mark it for all readers as the Answer and helpful!

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

• Search "MSCONFIG" and Open.
• Click on Boot Tab
• Tick Safe Boot in Boot Option
• Select Network.
• Click Apply and OK.
• Reboot your System.

Recommended Method to Fix the Problem: Calculate the number of months and days between two dates:

How to Fix Calculate the number of months and days between two dates with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will scan your system. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.

Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.2.2.0.0 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.2.2.3.0 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.2.0.6.22 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.1.1.88.1 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: Tech Support: BSOD (0x8e) by mpfltr.sys,Solution to Problem: Bluetooth phone disconnects about 7 seconds after pairing with windows 8.1 laptop,How to Fix - Bluetooth mouse problems with windows 7 ultimate?,Solution to Error: BSOD - Formatted, Reinstalled, Still BCC Code F4 - Please help (dump file attached),Fast Solution to Problem: BSOD Win 7 Pro BCCode: a0,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work