I’m looking to calculate a cell two different ways depending on whether or not it’s blank. For example: if cell B1 is blank, I want to calculate “Today()-A1”. If it is not blank, I want to calculate “B1-A1”.
How would I put that into a formula that works? I can’t make it work in an IF Statement.