month count

D

David

How to set a formula to count the number of month between two dates?
example:
Jan 5,2009 to Feb 4, 2009 = 1 month
Feb 5, 2009 to Apr 6, 2009 = 3 month (round up)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Merge text from multiple sources 0
How can count the number of cells that fulfill certain criteria in other cells 2
Chart moves on plot area when adding a third month 2
Creating a Search using a combo box and then creating a report. 4
Countifs or a pivot 1
Pivot Table Formulas 0
How do I set up S-curve 1
Find the position of a date 6

Top