Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Excel formula to count how many months from today (cell has formula already)
Hi Experts,
I have another excel request.
I need help with a formula that tells me the difference in months.
I can do this with static dates just fine,. But my date cell has a formula already and I get an error.
See attached dummy sheet as well.
Thanks
Chris
Example
dummy-sheet-difference-in-months.xlsx
I have another excel request.
I need help with a formula that tells me the difference in months.
I can do this with static dates just fine,. But my date cell has a formula already and I get an error.
See attached dummy sheet as well.
Thanks
Chris
Example
dummy-sheet-difference-in-months.xlsx
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
This can be done with the DATEDIF function
=DATEDIF(Start, Finish, Option)
or in your sheet:
=DATEDIF(B4,D4,"m")
=DATEDIF(Start, Finish, Option)
or in your sheet:
=DATEDIF(B4,D4,"m")
DATEDIF gives only whole months between the two dates, ie in your example it will change to 7 on 6 December.
There is also the YEARFRAC function that can give more accuracy
There is also the YEARFRAC function that can give more accuracy
If you want to disregard the days and just look for the difference in the months, you can try this:
=MONTH(D4)-MONTH(B4)
Paul
=MONTH(D4)-MONTH(B4)
Paul
Premium Content
You need an Expert Office subscription to comment.Start Free Trial