| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 . |
|
#3
|
|||
|
|||
|
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 . . |
|
#4
|
|||
|
|||
|
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 . . . |
|
#5
|
|||
|
|||
|
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 . . . . |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count for present & absent days | Excel Discussion (Misc queries) | |||
| Is there a WorkDay() type function that count all days except tho. | Excel Worksheet Functions | |||
| Count number of days in given month? | Excel Worksheet Functions | |||
| Count Days excluding Sundays | Excel Worksheet Functions | |||
| how do I make a function to count days? | Excel Worksheet Functions | |||
Linear Mode
