| Home |
| Search |
| Today's Posts |
|
#10
|
|||
|
|||
DateDif Average? Damn DateDif
You need to confirm that formula with control+shift+enter, not just with
enter. YvonneB wrote: OK, I've put in the following forumula and asked it to look at the actual date column (not the length of service result). However it keeps coming up as #VALUE! =DATEDIF(AVERAGE(J4:J62),TODAY(),"y") & "." & DATEDIF(J4:J62,TODAY(),"ym") Am i being really stupid here? Thanks Yvonne [...] |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| plotted Average | Charts and Charting in Excel | |||
| Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
| What is this kind of average called? | Excel Worksheet Functions | |||
| average function in Excel 2002 | New Users to Excel | |||
Threaded Mode
