How to count # of Month between two period
It is my first time to post but I used your forum in numerous instances. After searching the forum, I did not find the answer to my question which should be quite simple.
What formula could I use in order to have the # of months between two periods?
For example, I would like my cell C1 to show me the # of months (for this example, "C1" would be 28.
A B C
1 01/01/2002 1/05/2005 =# of months
Thanks in advance,
Here's a solution: http://www.cpearson.com/excel/datedif.htm
The DATEDIF(...) function is a function with a very special history
Hope it helped
Last edited by olasa; 05-09-2005 at 05:45 PM.
Thanks a lot, you solve my problem.
It is really appreciated.
You're welcome...and thanks for the feedback
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1