I need to find the number of days between the earliest creation date (column D) and latest End Date (column F) for a single request. The request number is sometimes listed multiple times (column C), which is why I'm having trouble sort by the real creation and end dates. Please Help!
Thanks!!
Your example only has data in columns A to D, so in cell E2, try this array formula:
Confirm as an array formula with Ctrl-Shift-Enter.
Please Login or Register to view this content.
Copy/Autofill down.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks