IF CELL A1 HAVE DATA IN COPY DATE IN B2
Solved/Closed
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
Thanks
Related:
- Insert the current date and time in cell a1
- Popcorn time download - Download - Movies, series and TV
- How to change date and time in whatsapp - Guide
- Insert check mark in word - Guide
- Insert draft watermark in word on all pages - Guide
- 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())
