| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need a function (UDF) return X if 2 dates fall between 2 other dates | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
