Link to home
Start Free TrialLog in
Avatar of chris pike
chris pikeFlag for Canada

asked on

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.
Example      User generated imagedummy-sheet-difference-in-months.xlsx
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

You may simple try this...


Open in new window

This can be done with the DATEDIF function

=DATEDIF(Start, Finish, Option)

or in your sheet:
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chris pike


Rob I tried that but because I have formulas populating the source of the date cell I get errors
The source cells having formulas shouldn't cause any issue
If you want to disregard the days and just look for the difference in the months, you can try this:


Thanks for the extra help with the YEARFRAC function solution Rob.
This is what I was looking for,

Thanks Neeraj
Thanks Chris. Glad you found a solution!