From: Ken on 19 May 2010 11:20 Excel2003 ... Range C7:C272 contains Dates format = mm/dd/yy (& empty cells) Looking for 3 Formulas for dates occuring as follows: Cell C275 ... Count Dates __ Today () <= -365 Cell C276 ... Count Dates between ___ Today() > -365 & Today() <= -730 Cell C277 ... Count Dates __ Today() > -730 Count dates occuring between Today & last 365 days Count dates occuring between last 366 days and 730 days Count dates occuring last 730+ days Thanks ... Kha -- Kha From: Per Jessen on 19 May 2010 13:22 HI In C275: =COUNTIF(C7:C272;"<=" &TODAY())-C276 In C276: =COUNTIF(C7:C272;"<" &ODAY()-365)-C277 In C277: =COUNTIF(C7:C272;"<" &TODAY()-730) Regards, Per "Ken" skrev i meddelelsen news:F58F790B-0B46-4C52-904D-50E1DF96C897(a)microsoft.com...> Excel2003 ... > > Range C7:C272 contains Dates format = mm/dd/yy (& empty cells) > > Looking for 3 Formulas for dates occuring as follows: > > Cell C275 ... Count Dates __ Today () <= -365 > Cell C276 ... Count Dates between ___ Today() > -365 & Today() <= -730 > Cell C277 ... Count Dates __ Today() > -730 > > Count dates occuring between Today & last 365 days > Count dates occuring between last 366 days and 730 days > Count dates occuring last 730+ days > > Thanks ... Kha > > > -- > Kha From: Ken on 19 May 2010 16:08 Per ... with a little gyration ... Did it ... Thanks ... Kha -- Kha "Per Jessen" wrote: > HI > > In C275: =COUNTIF(C7:C272;"<=" &TODAY())-C276 > In C276: =COUNTIF(C7:C272;"<" &ODAY()-365)-C277 > In C277: =COUNTIF(C7:C272;"<" &TODAY()-730) > > Regards, > Per > > "Ken" skrev i meddelelsen > news:F58F790B-0B46-4C52-904D-50E1DF96C897(a)microsoft.com... > > Excel2003 ... > > > > Range C7:C272 contains Dates format = mm/dd/yy (& empty cells) > > > > Looking for 3 Formulas for dates occuring as follows: > > > > Cell C275 ... Count Dates __ Today () <= -365 > > Cell C276 ... Count Dates between ___ Today() > -365 & Today() <= -730 > > Cell C277 ... Count Dates __ Today() > -730 > > > > Count dates occuring between Today & last 365 days > > Count dates occuring between last 366 days and 730 days > > Count dates occuring last 730+ days > > > > Thanks ... Kha > > > > > > -- > > Kha > > . >