in excel, if i want to use an if statement with a blank cell to put today's date in another cell and if not blank put contents of that cell what should I do?
Example:
Data is in J2, some have dates, some are blank. I want to calculate the different between J2 and G2. But with a blank cell, it's putting G2 in the column I'm working with. How do I insert today's date so it can subtract?
Solved by C. B. in 21 mins