ExcelBanter - Formula: How to write.."if A2 is blank then b2=today's date?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula: How to write.."if A2 is blank then b2=today's date? (https://www.excelbanter.com/excel-programming/340992-formula-how-write-if-a2-blank-then-b2%3Dtodays-date.html)

wheresleo

Formula: How to write.."if A2 is blank then b2=today's date?

I need help with the syntax for the following formula in excel

Formula: How to write.."if A2 is blank then b2=today's date?

Gary''s Student

Formula: How to write.."if A2 is blank then b2=today's date?

In cell B2 enter:

=IF(A2="",TODAY(),"")
--
Gary''s Student

"wheresleo" wrote:

I need help with the syntax for the following formula in excel

Formula: How to write.."if A2 is blank then b2=today's date?

All times are GMT +1. The time now is 07:29 AM.