I recently saw a post about using a LAMBDA function for the dates for yesterday and tomorrow. You don’t need to use LAMBDA, you can just use range names. In the image below I have used two range names to return yesterday’s and tomorrow’s date. The range names and their formulas are shown in the … Continue reading Yesterday and Tomorrow in Excel