Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Number of dates falling in a date range
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Cralis, post: 3799132"] Thanks Biff, I'm not getting the correct result. This is what I have tried, based on your assistance. =COUNTIF( 'Public Holidays'!$B$4:$B$400,">="&B5)-COUNTIF( 'Public Holidays'!$B$4:$B$400,">"&C5) The holidays are in a column on 'Public Holidays' spreadsheet. The cell (for this row) that has the start date is B5, with C5 holding the End Date. I have Zero display switched off, and with that, this is returning no value. Have I done something wrong? [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Number of dates falling in a date range
Top
