**Question description:**

*This user has given permission to use the problem statement for this
blog.*

Hi, I am using the dated if function and it works for most values but not all even though the formulas and formats are all the same - can you help?

Solved by V. J. in 37 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
14/12/2017 - 02:43

Hello, Welcome to Got It pro

User
14/12/2017 - 02:43

Hi

Excelchat Expert
14/12/2017 - 02:44

How may I help you?

User
14/12/2017 - 02:44

So, I am using a datedif function to return the number of months

Excelchat Expert
14/12/2017 - 02:45

ok

Excelchat Expert
14/12/2017 - 02:45

Please paste your data here

User
14/12/2017 - 02:45

one sec let me do now

User
14/12/2017 - 02:46

sorry excel has crashed - let me open and upload file

Excelchat Expert
14/12/2017 - 02:46

Ok

User
14/12/2017 - 02:47

Sorry taking a while to open - please bear with me

Excelchat Expert
14/12/2017 - 02:48

No problem Sir

User
14/12/2017 - 02:49

It's not opening - I will type it out

Excelchat Expert
14/12/2017 - 02:49

Ok

User
14/12/2017 - 02:52

Why does the cell highlighted not return 7?

Excelchat Expert
14/12/2017 - 02:55

you want to find difference in month

Excelchat Expert
14/12/2017 - 02:55

right?

User
14/12/2017 - 02:55

Yes

Excelchat Expert
14/12/2017 - 02:55

ignoring years?

User
14/12/2017 - 02:55

yes

Excelchat Expert
14/12/2017 - 02:55

and days?

User
14/12/2017 - 02:55

no just months

User
14/12/2017 - 02:56

yes ignoring days and years

Excelchat Expert
14/12/2017 - 02:56

ok

User
14/12/2017 - 02:56

I'm confused as it works on all my other dates

Excelchat Expert
14/12/2017 - 02:57

o

Excelchat Expert
14/12/2017 - 02:57

Please wait

User
14/12/2017 - 02:57

sorry

Excelchat Expert
14/12/2017 - 03:03

See cell H7

Excelchat Expert
14/12/2017 - 03:03

there I am getting right result

Excelchat Expert
14/12/2017 - 03:04

But, in C11, It's not coming

Excelchat Expert
14/12/2017 - 03:04

data is same for both

User
14/12/2017 - 03:04

But should be 7

User
14/12/2017 - 03:05

if including nov

Excelchat Expert
14/12/2017 - 03:05

Yes

Excelchat Expert
14/12/2017 - 03:05

but the formula doesn't include it

Excelchat Expert
14/12/2017 - 03:05

As per formula, it is : 11-6 = 5

Excelchat Expert
14/12/2017 - 03:05

So, if I add 1 , then it will be 6

User
14/12/2017 - 03:06

I need the number of month between Nov17-Jun18 which is 7 months

Excelchat Expert
14/12/2017 - 03:06

No, that's not true

User
14/12/2017 - 03:07

6 is not correct either

Excelchat Expert
14/12/2017 - 03:07

if you include both the months

User
14/12/2017 - 03:07

sorry 8

Excelchat Expert
14/12/2017 - 03:07

then also, it will be 6 at max

Excelchat Expert
14/12/2017 - 03:07

June, july, aug, Sept, Oct., Nov.

Excelchat Expert
14/12/2017 - 03:07

which is = 1+1+1+1+1+1 = 6

User
14/12/2017 - 03:07

Nov, dec 17, Jan, Feb, mAr, apr, may,jun

User
14/12/2017 - 03:08

nov dec 17 and the rest in 2018

Excelchat Expert
14/12/2017 - 03:08

ok got it

Excelchat Expert
14/12/2017 - 03:08

the other way

Excelchat Expert
14/12/2017 - 03:08

then 8 is correct

Excelchat Expert
14/12/2017 - 03:08

if you add 1

Excelchat Expert
14/12/2017 - 03:09

because formula by default includes one of the end months

User
14/12/2017 - 03:09

The number in cell B11 should then be 9?

User
14/12/2017 - 03:10

I'm confused as the dates in B10 and C10 are a month apart but return the same number of months

User
14/12/2017 - 03:10

I would expect the number of months to change by 1 given that we are on the next month

Excelchat Expert
14/12/2017 - 03:11

Ohh, this has something to do with end dates of month

Excelchat Expert
14/12/2017 - 03:12

each date is either 30 or 31st

User
14/12/2017 - 03:12

or 28th in the case of Feb

Excelchat Expert
14/12/2017 - 03:12

yes

User
14/12/2017 - 03:12

0r 29th

Excelchat Expert
14/12/2017 - 03:13

My suggestion is that, just use month() function

User
14/12/2017 - 03:14

Ok...

Excelchat Expert
14/12/2017 - 03:15

Anything else, I may help you with?

User
14/12/2017 - 03:15

how does that work?

Excelchat Expert
14/12/2017 - 03:17

Please see row 12

User
14/12/2017 - 03:18

ok thank you

Excelchat Expert
14/12/2017 - 03:18

Welcome :)

Excelchat Expert
14/12/2017 - 03:18

Thanks for your patience!

Excelchat Expert
14/12/2017 - 03:18

Have a great day :)

Excelchat Expert
14/12/2017 - 03:18

Please leave your valuable feedback :)

Excelchat Expert
14/12/2017 - 03:19

You may close the session now from above button

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*