I am trying to make excel show a specific day/date of the week in a cell. For example I always want the next Tuesday's date to show in a cell, or if today is Tuesday then I want it to show today. Any one know how I might do this?

thanks in advance