• 544K Members
• 4,556 Online
• 648K Conversations
SOLVED

Highlighted
New Contributor

# Value fall between dates? Looking retrospectively

Hi!

I have a sheet that includes in each row, a start date cell and a finish date cell. Third cell per row I've got happily set up to tell me the working day difference between the start and finish date (or TODAY if unfinished).

How can I set up something like a COUNTIF to show me how many unfinished items there were on a particular day, and then how many working days each item had been open for on that particular day?

5 Replies
Highlighted

# Re: Value fall between dates? Looking retrospectively

Would you be able share a sample worksheet with some example data points and expected result ?  That will help you and contributors here to get a quicker and better solution for you.

Highlighted
Solution

# Re: Value fall between dates? Looking retrospectively

For such sample

that could be like

``=COUNTIFS(B:B,">"&\$G\$2,A:A,"<="&\$G\$2)``

Workdays opened on that date

``=IF( (A2<=\$G\$2)*(B2>=\$G\$2),NETWORKDAYS(A2,MIN(B2,\$G\$2)),0)``
Highlighted

# Re: Value fall between dates? Looking retrospectively

Thanks Kodipady was my first post but will definitely keep it in mind for any future posts!
Highlighted

# Re: Value fall between dates? Looking retrospectively

Thanks Sergei! Always looks so simple once it's laid out. Works a charm!
Highlighted

# Re: Value fall between dates? Looking retrospectively

@tsaurus , you are welcome

Related Conversations
Date filtering of Bing Searches
PhilipE3 in Discussions on
2 Replies
Setting Date in Stored Procedure
Tim Hunter in SQL Server on
1 Replies
if then formula help
BMARSH99 in Excel on
1 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Date Calculator / Seasonal rates
Brian Thornton in Excel on
2 Replies