Use Datedif but for future dates

I have a formula for identifying years, months, days from a past date to 
now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& " M, " & 
DATEDIF(C6,NOW(),"md") & " D"

I'd like a formula that can produce the same format (years, months, days) 
between now and a future date.

Any ideas?

Thanks in advance,

Bart 


0
bartmacl (39)
9/1/2006 7:09:49 PM
excel 39879 articles. 2 followers. Follow

4 Replies
2073 Views

Similar Articles

[PageSpeed] 22

Hi Bart

Try this with the date in A2

=IF(TODAY()<=A2,DATEDIF(TODAY(),A2,"Y") & " y " & DATEDIF(TODAY(),A2,"ym") & " m","-"&DATEDIF(A2,TODAY(),"y")& " y " 
&DATEDIF(A2,TODAY(),"ym")& " m")

-- 
Regards Ron de Bruin
http://www.rondebruin.nl



"bam" <bartmacl@yahoo.com> wrote in message news:%2309qzofzGHA.4392@TK2MSFTNGP04.phx.gbl...
>I have a formula for identifying years, months, days from a past date to now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& 
>" M, " & DATEDIF(C6,NOW(),"md") & " D"
>
> I'd like a formula that can produce the same format (years, months, days) between now and a future date.
>
> Any ideas?
>
> Thanks in advance,
>
> Bart
> 


0
rondebruin (3790)
9/1/2006 7:54:23 PM
Oops, This is the correct one for YMD

=IF(TODAY()<=A2,DATEDIF(TODAY(),A2,"y") & " y " & DATEDIF(TODAY(),A2,"ym") & " m " & DATEDIF(TODAY(),A2,"md") & " 
d","-"&DATEDIF(A2,TODAY(),"y") & " y " &DATEDIF(A2,TODAY(),"ym") & " m "  &DATEDIF(A2,TODAY(),"md") & " d ")

-- 
Regards Ron de Bruin
http://www.rondebruin.nl



"bam" <bartmacl@yahoo.com> wrote in message news:%2309qzofzGHA.4392@TK2MSFTNGP04.phx.gbl...
>I have a formula for identifying years, months, days from a past date to now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& 
>" M, " & DATEDIF(C6,NOW(),"md") & " D"
>
> I'd like a formula that can produce the same format (years, months, days) between now and a future date.
>
> Any ideas?
>
> Thanks in advance,
>
> Bart
> 


0
rondebruin (3790)
9/1/2006 7:56:28 PM
Wow, nice. That does it. Thanks very much
Bart

"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message 
news:eFh03CgzGHA.3568@TK2MSFTNGP03.phx.gbl...
> Oops, This is the correct one for YMD
>
> =IF(TODAY()<=A2,DATEDIF(TODAY(),A2,"y") & " y " & DATEDIF(TODAY(),A2,"ym") 
> & " m " & DATEDIF(TODAY(),A2,"md") & " d","-"&DATEDIF(A2,TODAY(),"y") & " 
> y " &DATEDIF(A2,TODAY(),"ym") & " m "  &DATEDIF(A2,TODAY(),"md") & " d ")
>
> -- 
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "bam" <bartmacl@yahoo.com> wrote in message 
> news:%2309qzofzGHA.4392@TK2MSFTNGP04.phx.gbl...
>>I have a formula for identifying years, months, days from a past date to 
>>now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& " M, " & 
>>DATEDIF(C6,NOW(),"md") & " D"
>>
>> I'd like a formula that can produce the same format (years, months, days) 
>> between now and a future date.
>>
>> Any ideas?
>>
>> Thanks in advance,
>>
>> Bart
>>
>
> 


0
bartmacl (39)
9/1/2006 8:06:10 PM
Swap your references around.

DATEDIF(NOW(),C6,  etc.

Earliest date must be first.


Gord Dibben  MS Excel MVP

On Fri, 1 Sep 2006 12:09:49 -0700, "bam" <bartmacl@yahoo.com> wrote:

>I have a formula for identifying years, months, days from a past date to 
>now. DATEDIF(C6,NOW(),"y")&" Y, "& DATEDIF(C6,NOW(),"ym")& " M, " & 
>DATEDIF(C6,NOW(),"md") & " D"
>
>I'd like a formula that can produce the same format (years, months, days) 
>between now and a future date.
>
>Any ideas?
>
>Thanks in advance,
>
>Bart 
>

0
Gord
9/1/2006 8:13:09 PM
Reply:

Similar Artilces: