-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Format Cell in Months
- Thread starter minnie
- Start date
Joe Was
MrExcel MVP
- Joined
- Feb 19, 2002
- Messages
- 7,539
=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"ym")& " months")
This will give only the months portion of the between date. It will not convert the years to month though.
Like: 2 years 3 months will = 3 months, not 27 months!
And:
=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"m")& " months")
will give you your 27 months for 2 years and 3 months. Hope this helps. JSW
This message was edited by Joe Was on 2002-04-26 08:40
This will give only the months portion of the between date. It will not convert the years to month though.
Like: 2 years 3 months will = 3 months, not 27 months!
And:
=IF(OR(F13="",F16=""),"Enter Both Dates Above!", DATEDIF(F13,F16,"m")& " months")
will give you your 27 months for 2 years and 3 months. Hope this helps. JSW
This message was edited by Joe Was on 2002-04-26 08:40
Upvote
0
