Prev: Adding to an existing Pivot Table
Next: SUM IF: How do I sum the data in a column based on 2 other columns
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" <Ken(a)discussions.microsoft.com> 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" <Ken(a)discussions.microsoft.com> 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
>
> .
>
 | 
Pages: 1
Prev: Adding to an existing Pivot Table
Next: SUM IF: How do I sum the data in a column based on 2 other columns