Formula that displays the oldest date in column A and earliest date in column B, then displaying how many days between the two dates are. Please see attached file!!
Formula that displays the oldest date in column A and earliest date in column B, then displaying how many days between the two dates are. Please see attached file!!
use something like
= min(A:A) - max(B:B)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
When I do this, I get a zero (0) value?
OK check attachment array formula cofirmed CTRL + SHIFT + ENTER
THANKS, just what I needed!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks