[Solved] Calculating Months

Calculating Months

I have 2 variables; Effective Date in Column A & Duration in Column B.

 
I have a project that starts 1/1/2013 and has a duration of 36 months:
Column C needs to show 12 for the active months in Calendar Year 13.

Column D needs to show 12 for the active months in Calendar Year 14.

Column E needs to show 12 for the active months in Calendar Year 15.

 
My projects will never go over 36 months, but could be less i.e.:
 
I have a project that starts 6/1/2013 and runs for 18 months.

Column C should show 7 for the active months in Calendar Year 13.

Column D should show 11 for the active months in Calendar Year 14.

Column E would be zero.

 
What would the formulas be in Column C, D, & E for my many projects?

Anwsers to the Problem Calculating Months

Download Error Fixer (Free)

Hi,
 
Assuming the dates in column A are the first dates of any month, try these formulas
 
1.
In cell C1, enter this formula
 
=MIN(12-MONTH(A1)+1,B1)
 
2.
In cell D1, enter this formula
 
=IF(EDATE(A1,24)-1<=EDATE(A1,B1)-1,12,MONTH(EDATE(A1,B1)-1))
 
3.
In cell E1, enter this formula
 
=B1-SUM(C1:D1)
 
Hope this helps.

Tweak IE Options

• Open Internet Explorer.
• Go to "Tools > Internet Options > Advanced Tab".
• Uncheck "Enable third-party browser extensions".
• Click "Apply".
  
• Reboot your computer.

Recommended Method to Fix the Problem: Calculating Months:

How to Fix Calculating Months with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will perform a scan for your computer. The errors will be shown in the scan result.

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

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed

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: C \/ C++ on Windows 7 ultimate 32 Bit [Anwsered],browser highlighter not working properly,How Can I Fix - Both audio jack messages the same?,Troubleshooter of Error: BTTray error: unable to start bluetooth stack service with windows 7 home premium o\/s,How Can I Fix - Browser keeps loading http:\\\\myclock.info\\fp\\index.html... Why??,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