On Wednesday, April 25, 2018 at 8:28:34 AM UTC-5, Claus Busch wrote:
Hi,

Am Tue, 24 Apr 2018 11:20:12 -0700 (PDT) schrieb
:

4/2/18 4/3/18 4/4/18 4/5/18 4/6/18 4/7/18 4/8/18 4/9/18
John q q e q q w w q
Mary q q e q q w w e
William q q q q q w w e

4/4/2018
e

try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))="e",ROW($1:$4)),ROW(A1)))," ")
Enter this formula with CTRL+Shift+Enter and then copy down.


Regards
Claus B.
--
Windows10
Office 2016

Hello Claus, Thank you for your help, does it matter what cell would I put in this formula for it to work?