Anthony, Correct! First one was a typo on my part. I'll add this to my website this evening - after dance classes and girl guides and ... :)
Dave On 11/3/05, Anthony Chilco <[EMAIL PROTECTED]> wrote: > Hi David, > I tried it both ways. Only one works. > tc > > David Chapman wrote: > > >I respectfully stand by my formula - as well as the assertion that > >mm/dd/yy format can be used in conditional expressions inside the > >countif function. > > > >On 11/3/05, Anthony Chilco <[EMAIL PROTECTED]> wrote: > > > > > >>Hi David and Robert, > >> > >>It should be: > >> > >>=(COUNTIF(A1:A100;"<10/17/02")+COUNTIF(A1:A100;">10/23/02"))-COUNT(A1:A100) > >> > >>Except that you can't use date formats if the cells you're counting > contain > >>real dates. You'll have to use the numbers that represent the dates: > >> > >> Date Date as number Add comparison operator > >>12/29/05 38715.64 >38715.6362420139 > >> > >> So it looks like: > >> > >>=COUNTIF(A1:A100;">38715.6362420139")+COUNTIF(A1:A100;"<39079.6362420139")-COUNT(A1:A100) > >> > >>tc > >> > >> > >>David Chapman wrote: > >> > >> > >> > >>>Should be.. > >>> > >>>=COUNT(A1:A100)-(COUNTIF(A1:A100;"<10/17/02")+COUNTIF(A1:A100;">10/23/02")) > >>> > >>>On 11/3/05, David Chapman <[EMAIL PROTECTED]> wrote: > >>> > >>> > >>> > >>> > >>>>Example, > >>>> > >>>>Count cells between 10/17/02 and 10/23/02 inclusive... > >>>> > >>>>=COUNTIF(A1:A100)-(COUNTIF(A1:A100;"<10/17/02")+COUNTIF(A1:A100;">10/23/02")) > >>>> > >>>>On 11/3/05, Robert Volke <[EMAIL PROTECTED]> wrote: > >>>> > >>>> > >>>> > >>>> > >>>>>I've looked all over and I can't seem to figure out how to count the > >>>>>number of cells in a column that contain a date within a specific date > >>>>>range, aside from manually counting them. I can do this, but it would > >>>>>make life much easier to have this information automatically populated > >>>>>in my summary sheet upon each update. There may a function that I can > >>>>>use to count these occurrence but I have been unable to determine it > so > >>>>>far. Thank you for your help. > >>>>> > >>>>>Robert > >>>>> > >>>>> > >>>>> > >>>>>--------------------------------------------------------------------- > >>>>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>>>For additional commands, e-mail: [EMAIL PROTECTED] > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>-- > >>>>My OpenOffice Calc Website > >>>>http://www.openofficetips.com > >>>> > >>>> > >>>> > >>>> > >>>> > >>>-- > >>>My OpenOffice Calc Website > >>>http://www.openofficetips.com > >>> > >>>--------------------------------------------------------------------- > >>>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>>For additional commands, e-mail: [EMAIL PROTECTED] > >>> > >>> > >>> > >>> > >>> > >>> > >>--------------------------------------------------------------------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > >> > > > > > >-- > >My OpenOffice Calc Website > >http://www.openofficetips.com > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
