# Date Question

#### DDH

##### Well-known Member
I am trying to subtract between two date and I have something wrong and I don't what.

-----------B--------C--------------D-----------
16-----4/8/13-----------------0 Mo, 0 Da----
17-----3-30-13--------------------------------

Formula in cell D16
INT(MOD(B16-B17,365)/30)&" Mo, "&ROUND(MOD((MOD(B16-B17,365)),30),0)&" Da"

Cell D16 should say 9 Da

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
=day(b16-b17) & " Da"

maybe something like...

=DATEDIF(B2,B1,"ym")&" Months"&" "&DATEDIF(B2,B1,"md")&" Days"

Would this be any help?

Are you sure that both cells contain dates? The ISNUMBER function will return TRUE if they do.

Andrew Poulsom - Yes I have dates in each cell (B17 - 3/30/13) (B16 - 4/8/13).
Peter_SSs - There was nothing posted?
Weazel - I tried you formula and I could not get it to work?
nuked - I need Month & Day to show.

I guess in my formula I was trying it get to caculate days and then divide a average month (30)
into it which would give the months and then the difference woould be days.
Example - (B11 - 11/3/12), (B10 - 1/20/13) answer in (E10 - 2Mo, 18 Da)

If they are both dates your formula returns 0 Mo, 9 Da.

It is working now, I must have done something wrong before.
I am sorry for bothering all of you.

Thank you for trying to help me.

Peter_SSs - There was nothing posted?
The word "this" in my post is underlined and is a hyperlink. Click it and you will see what I was referring to.

Peter_SSs - Thank you for pointing that out, I blame that my old age for not seeing that.

Of course I blame a lot of things on my old age.

Replies
1
Views
899
Replies
1
Views
85
Replies
4
Views
113
Replies
6
Views
448
Replies
34
Views
1K

1,207,090
Messages
6,076,520
Members
446,211
Latest member
b306750

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back