Count Dates & Return as %
 

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

Count Dates & Return as %
 

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
...
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

Count Dates & Return as %
 

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
...
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

.