Count of days
 

Can someone tell me how to correct the formula to count
the days across a year?

This formula is returning 25 days, which is wrong.

=DATEDIF(I5,D5,"yd") & " day" & IF(DATEDIF(I5,D5,"yd")
<1,"s","")
D5 contains =TODAY()
I5 contains =MAX(('Export'!D3:D9999<TODAY())*('Export'!
D3:D9999)) (array entered) and is 2/5/2004 Feb.5, 2004.


It was accurate once but I do not know what is wrong! Is
it the year change?

TIA

Hi!

When I do this:

=TODAY()-"2/5/2005"

I get 25.

This formula is returning 25 days, which is wrong.

What result are you expecting?

Biff

-----Original Message-----
Can someone tell me how to correct the formula to count
the days across a year?

This formula is returning 25 days, which is wrong.

=DATEDIF(I5,D5,"yd") & " day" & IF(DATEDIF(I5,D5,"yd")
<1,"s","")
D5 contains =TODAY()
I5 contains =MAX(('Export'!D3:D9999<TODAY())*('Export'!
D3:D9999)) (array entered) and is 2/5/2004 Feb.5, 2004.


It was accurate once but I do not know what is wrong! Is
it the year change?

TIA
.

Ooops!

I see I used the wrong year! Sorry.

Biff

-----Original Message-----
Hi!

When I do this:

=TODAY()-"2/5/2005"

I get 25.

This formula is returning 25 days, which is wrong.

What result are you expecting?

Biff

-----Original Message-----
Can someone tell me how to correct the formula to count
the days across a year?

This formula is returning 25 days, which is wrong.

=DATEDIF(I5,D5,"yd") & " day" & IF(DATEDIF(I5,D5,"yd")
<1,"s","")
D5 contains =TODAY()
I5 contains =MAX(('Export'!D3:D9999<TODAY())*('Export'!
D3:D9999)) (array entered) and is 2/5/2004 Feb.5, 2004.


It was accurate once but I do not know what is wrong! Is
it the year change?

TIA
.

.

HI!

Why not just use this:

=D5-I5&" day"&IF(D5-I5<1,"s","")

returns: 391 days

Biff

-----Original Message-----
Ooops!

I see I used the wrong year! Sorry.

Biff

-----Original Message-----
Hi!

When I do this:

=TODAY()-"2/5/2005"

I get 25.

This formula is returning 25 days, which is wrong.

What result are you expecting?

Biff

-----Original Message-----
Can someone tell me how to correct the formula to count
the days across a year?

This formula is returning 25 days, which is wrong.

=DATEDIF(I5,D5,"yd") & " day" & IF(DATEDIF(I5,D5,"yd")
<1,"s","")
D5 contains =TODAY()
I5 contains =MAX(('Export'!D3:D9999<TODAY())*('Export'!
D3:D9999)) (array entered) and is 2/5/2004 Feb.5, 2004.


It was accurate once but I do not know what is wrong!
Is
it the year change?

TIA
.

.

.

Thanks Biff, I never looked beyond the workbook I
inherited.
Works great now!
-----Original Message-----
HI!

Why not just use this:

=D5-I5&" day"&IF(D5-I5<1,"s","")

returns: 391 days

Biff

-----Original Message-----
Ooops!

I see I used the wrong year! Sorry.

Biff

-----Original Message-----
Hi!

When I do this:

=TODAY()-"2/5/2005"

I get 25.

This formula is returning 25 days, which is wrong.

What result are you expecting?

Biff

-----Original Message-----
Can someone tell me how to correct the formula to
count
the days across a year?

This formula is returning 25 days, which is wrong.

=DATEDIF(I5,D5,"yd") & " day" & IF(DATEDIF(I5,D5,"yd")
<1,"s","")
D5 contains =TODAY()
I5 contains =MAX(('Export'!D3:D9999<TODAY())*('Export'!
D3:D9999)) (array entered) and is 2/5/2004 Feb.5, 2004.


It was accurate once but I do not know what is wrong!
Is
it the year change?

TIA
.

.

.

.

The "yd" option means to return the number of days since the last anniversary
date. The starting date is 2/5/2004. The anniversary date is thus 2/5/2005. So
you are calculating the number of days from 2/5/2005 to the current date.

If you want the total number of days, you can just subtract the 2 dates, or
use the "d" option with DATEDIF, i.e.

=DATEDIF(I5,D5,"d")&" day"&IF(DATEDIF(I5,D5,"d")<1,"s","")

=D5-I5&" day"&IF(D5-I51,"s","")



On Wed, 2 Mar 2005 11:22:12 -0800, "Albert"
wrote:

Can someone tell me how to correct the formula to count
the days across a year?

This formula is returning 25 days, which is wrong.

=DATEDIF(I5,D5,"yd") & " day" & IF(DATEDIF(I5,D5,"yd")
<1,"s","")
D5 contains =TODAY()
I5 contains =MAX(('Export'!D3:D9999<TODAY())*('Export'!
D3:D9999)) (array entered) and is 2/5/2004 Feb.5, 2004.


It was accurate once but I do not know what is wrong! Is
it the year change?

TIA