IF CELL A1 HAVE DATA IN COPY DATE IN B2 [Solved/Closed]

Report
-
 StormDronk -
Hello, please can you help on how the following works in excel. In excel 2007: If cell a1 are 1,2 or 3 then the current date displays in b2, or if data is entered in a1 then the date shows in b1

Thanks



2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
Write this in B2
=IF(OR(A1=1, A1=2, A1=3), TODAY(),"")

in B1 write this
=IF(OR(A1=1, A1=2, A1=3, A1=""), "", TODAY())

You would have to format the cell b1, b2 as date, else it will show you some numbers



having said that I think you meant to say if there is data in A1 then show date in b2 and if there is no data in a1 then show date in b1. In that case
Write this in B2
=IF(A1 <>"", TODAY(),"")

in B1 write this
=IF A1="", "", TODAY())
Thanks this worked grate!!!!!!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!