Advertisement

10.02.2008 at 06:46AM PDT, ID: 23781506 | Points: 150
[x]
Attachment Details

Count If cell is empty 30 days before today

Asked by LasseA in Microsoft Excel Spreadsheet Software

Tags: , ,

I would like to count the number of customers that have not been assigned a [Delivery Date] when [Order Date] is more than 30 days ago (based on today() function). Sample list:

Order Date      Delivery Date
2008-10-01      2008-10-05
2008-10-02      
2008-10-03      2008-10-07
2008-10-04      2008-10-08
2008-10-05      
2008-10-06      2008-10-10

Conditions:
(1) List is in Excel 2007 tables, so formula must be something like =COUNTIF(Sales[Order Date]....
(2) No intermediate calculations, just one function
(3) Dynamically updated (based on today's date)Start Free Trial
 
Keywords: Count If cell is empty 30 days before …
Title
1 COUNTIF Formula that tests for tmore t…
2 CountIF statement not working properly
3 Cell formula (countif)
4 countif function
5 Count if cell contains specific text
6 CountIFS
 
Loading Advertisement...
 
[+][-]10.02.2008 at 08:36AM PDT, ID: 22625296

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.02.2008 at 08:56AM PDT, ID: 22625513

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.20.2008 at 11:20PM PST, ID: 23010975

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11.21.2008 at 12:54AM PST, ID: 23011265

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.21.2008 at 01:05AM PST, ID: 23011296

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.21.2008 at 04:01AM PST, ID: 23012171

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.21.2008 at 04:32AM PST, ID: 23012294

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.21.2008 at 06:09AM PST, ID: 23012888

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-44 / EE_QW_2_20070628