Date Question

[DDH]

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

Thank you for your help.

 

[nuked]

=day(b16-b17) & " Da"

 

[Weazel]

maybe something like...

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

 

[Peter_SSs]

Would this be any help?

 

[Andrew Poulsom]

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

 

[DDH]

Andrew Poulsom, Peter_SSs, Weazel, nuked - Thank you for your reply.

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)

Thank you for your help.

 

[Andrew Poulsom]

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

 

[DDH]

Andrew Poulsom - Thank you for your reply.

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]

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.

 

[DDH]

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.

Thank you for your help.