Here is my spreadsheet if you can go into it and put a formula that'll work or just see it. https://onedrive.live.com/redir?page...B0rMq_nlDNm4bw
This is a website pretty much explaining my problem https://answers.yahoo.com/question/i...1051352AAla2qV ... Im trying to make it were a number in a cell, formula, or macro change everyday, Im new to this so dont really understand much. Thanks