S Simont485 Joined Feb 23, 2018 Messages 67 Reaction score 24 Jun 9, 2019 #1 I need to count the days between today date and a previous date based on another cell. See attachment..... Any question please ask..... Attachments Date.zip Date.zip 8 KB · Views: 117
I need to count the days between today date and a previous date based on another cell. See attachment..... Any question please ask.....
S Simont485 Joined Feb 23, 2018 Messages 67 Reaction score 24 Jun 9, 2019 #2 =IFNA($B$2-LOOKUP(2,1/($C13:$I13="x"),$C$2:$I$2),"") This does it!!!
Ian Administrator Joined Feb 23, 2002 Messages 19,877 Reaction score 1,508 Jun 9, 2019 #3 Good work, thanks for reporting back with the solution .
.