column A = date of purchas
column b = name of custome
column c = phone numbe
...
column GC = discount

the range is from A2:GC(count of transactions

basically now im using =if(a2=today(),b2,""
same equation for column c,d,e...out to G

then that equation goes down about 10000 rows to cover all the possible trasanaction