Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif - recognition problems with dates
=COUNTIF(Pitches!$C$15:$C$67,"<=Pitches!B5+3") Im trying to get countif to recognise dates that are less than three days away. B5 is todays date.. Any suggestions on where I am going wrong? -- simoncottle ------------------------------------------------------------------------ simoncottle's Profile: http://www.excelforum.com/member.php...o&userid=33122 View this thread: http://www.excelforum.com/showthread...hreadid=529744 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif - recognition problems with dates
maybe...
=COUNTIF(Pitches!$C$15:$C$67,"<="&Pitches!B5+3) simoncottle wrote: =COUNTIF(Pitches!$C$15:$C$67,"<=Pitches!B5+3") Im trying to get countif to recognise dates that are less than three days away. B5 is todays date.. Any suggestions on where I am going wrong? -- simoncottle ------------------------------------------------------------------------ simoncottle's Profile: http://www.excelforum.com/member.php...o&userid=33122 View this thread: http://www.excelforum.com/showthread...hreadid=529744 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif - recognition problems with dates
This formula worked for me:
=SUMPRODUCT(--(Pitches!C15:C67<=Pitches!B5+3)) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif - recognition problems with dates
=COUNTIF(Pitches!$C$15:$C$67,"<=" & Pitches!B5+3)
"simoncottle" wrote: =COUNTIF(Pitches!$C$15:$C$67,"<=Pitches!B5+3") Im trying to get countif to recognise dates that are less than three days away. B5 is todays date.. Any suggestions on where I am going wrong? -- simoncottle ------------------------------------------------------------------------ simoncottle's Profile: http://www.excelforum.com/member.php...o&userid=33122 View this thread: http://www.excelforum.com/showthread...hreadid=529744 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif - recognition problems with dates
Thanks As an add onto this does anyone know how to use countif with multiple criteria I have dates of projects that are attached to names, but i want to be able to count only those projects at today +3 that are attached to certain names. At the moment i can count those with deadlines in the next three days but not attach those to names. I've tried being clever by separating out another table with the dates attached to new names, but this isnt working properly and isnt a neat solution Thanks Simon -- simoncottle ------------------------------------------------------------------------ simoncottle's Profile: http://www.excelforum.com/member.php...o&userid=33122 View this thread: http://www.excelforum.com/showthread...hreadid=529744 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif - recognition problems with dates
TRY:
=SUMPRODUCT(--(Pitches!C15:C67<=Pitches!B5+3),--(D15:D67=<name)) Replace <name with name e.g. "Fred" or cell reference containing name "simoncottle" wrote: Thanks As an add onto this does anyone know how to use countif with multiple criteria I have dates of projects that are attached to names, but i want to be able to count only those projects at today +3 that are attached to certain names. At the moment i can count those with deadlines in the next three days but not attach those to names. I've tried being clever by separating out another table with the dates attached to new names, but this isnt working properly and isnt a neat solution Thanks Simon -- simoncottle ------------------------------------------------------------------------ simoncottle's Profile: http://www.excelforum.com/member.php...o&userid=33122 View this thread: http://www.excelforum.com/showthread...hreadid=529744 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Having problems calculating dates in Excel. | Excel Worksheet Functions | |||
Countif on multiple dates | Excel Worksheet Functions | |||
COUNTIF using Dates | Excel Worksheet Functions | |||
Countif using dates | Excel Worksheet Functions | |||
COUNTIF With Multiple Dates, Columns and Text | Excel Worksheet Functions |