Hi guys, I'm really struggling.
I have a table of aircraft parking entries, where each aircraft is on separate row. To each aircraft is assigned a date, when parking began and another date, when parking ended. See image. Screenshot 2021-03-18 at 14.36.42.png
What I'm trying to do, is to generate a 2D line chart, where x axis is time from March 2020 to March 2021 and y axis is number of entries (number of a/c parked at given date).
Any ideas?
Thank you very much
Create your list of dates as a column - for example, enter the starting date in D2 (Assumes your table is in A:C)
1/3/20
And use this formula in D3, copied down:
=D2+1
Then, in E2, use the formula
=COUNTIFS(B:B,"<=" & D2, C:C, ">=" & D2)
And copy that down to match your list in D.
Bernie Deitrick
Excel MVP 2000-2010
You are amazing. Thank you, sir.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks