If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|