Age Avg
I need to have the avg age of a columum. I currently using this formula to
calc the age =DATEDIF(C96,NOW(),"y") & "y, " & DATEDIF(C96,NOW(),"ym") & "m, " & DATEDIF(C96,NOW(),"md") & "d" I need the avg to output in this way of the formula above |
Find the average of the column C, and then use the formula: =DATEDIF(AVERAGE(C1:C96),NOW(),"y") & "y, " & DATEDIF(AVERAGE(C1:C96),NOW(),"ym") & "m, " & DATEDIF(AVERAGE(C1:C96),NOW(),"md") & "d" Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=392789 |
All times are GMT +1. The time now is 05:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com