| 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 |
| 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 | |||
Threaded Mode
