| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Year formula
I have a row of birth dates on a sheet, and need a formula to determine how
many are over 60 years old. The cell format for the dates is 11/30/2009 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Year formula
Try
=IF(DATEDIF(A1,TODAY(),"y")=60,"60 or above","") OR year to year comparison =IF(YEAR(TODAY())-YEAR(A1)=60,"60 or above","") -- Jacob "Robert" wrote: I have a row of birth dates on a sheet, and need a formula to determine how many are over 60 years old. The cell format for the dates is 11/30/2009 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Year formula
Assume your dates are in the range A1:J1
Enter this formula in A2 and copy across to J2: =DATEDIF(A1,NOW(),"y") Then to count how many are greater than 60: =COUNTIF(A2:J2,"60") -- Biff Microsoft Excel MVP "Robert" wrote in message ... I have a row of birth dates on a sheet, and need a formula to determine how many are over 60 years old. The cell format for the dates is 11/30/2009 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Year formula
=if(datedif(D2,today(),"y")=60,"60 or above","")
I tried the above formula and the cell states "60 or above" instead of giving me a count of people over 60. Thanks "Jacob Skaria" wrote: Try =IF(DATEDIF(A1,TODAY(),"y")=60,"60 or above","") OR year to year comparison =IF(YEAR(TODAY())-YEAR(A1)=60,"60 or above","") -- Jacob "Robert" wrote: I have a row of birth dates on a sheet, and need a formula to determine how many are over 60 years old. The cell format for the dates is 11/30/2009 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Year formula
To return the count of say row1 cell references A1:J1 try the below
=SUMPRODUCT((DATEDIF(A1:J1,TODAY(),"y")=60)*(A1:J 10)) -- Jacob "Robert" wrote: =if(datedif(D2,today(),"y")=60,"60 or above","") I tried the above formula and the cell states "60 or above" instead of giving me a count of people over 60. Thanks "Jacob Skaria" wrote: Try =IF(DATEDIF(A1,TODAY(),"y")=60,"60 or above","") OR year to year comparison =IF(YEAR(TODAY())-YEAR(A1)=60,"60 or above","") -- Jacob "Robert" wrote: I have a row of birth dates on a sheet, and need a formula to determine how many are over 60 years old. The cell format for the dates is 11/30/2009 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert day of year to numeric value format year+day in 4 digits | Excel Worksheet Functions | |||
| How do I crate a function for week of year + year in same cell. | Excel Worksheet Functions | |||
| need formula 4 %change on both neg and pos movemnt year to year co | Excel Discussion (Misc queries) | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
Linear Mode
