IF CELL A1 HAVE DATA IN COPY DATE IN B2
Solved/Closed
Related:
- Insert the current date and time in cell a1
- Popcorn time download - Download - Movies, series and TV
- How to change whatsapp date and time - Guide
- Insert check mark in word - Guide
- Ocarina of time rom - Download - Action and adventure
- How to insert photo in word for resume - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 15, 2010 at 08:48 AM
May 15, 2010 at 08:48 AM
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())
=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())
