Link to home
Start Free TrialLog in
Avatar of Ted Penner
Ted PennerFlag for United States of America

asked on

Calculate number of months in Excel

How do I represent today less the value of cell in terms of number of months?

The below example shows my attempt
https://www.screencast.com/t/XoVirpBqlnn
SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

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

ASKER

Jeff,

Your solution appears more solid but I still get an error in the top cell.

https://www.screencast.com/t/7Z3RufemZb
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Number should always be positive and if not a positive number of months, then the value should be zero.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think the values should be 9 and 21 if not past the expiration date as shown here.

https://docs.google.com/spreadsheets/d/1cjS8qfytLJwIwbId5xfNmHm5NxsX_9gwWYxbO_B55AA/edit?usp=sharing
With my last provided solution, you are getting 9 & 21
User generated image
Thank you!!
Please to help!