G
Guest
I have a cell in which that if the cell to the immediate left is true, then
the cell that I'm in needs to automatically put in both the username and the
date and time. I can do each one alone but not together. The closest that I
got is when the date came up the Excel way and not mm/dd/yyyy.
I had: =IF (B1=True, ThisUser() & " " & Now(), " ")
Please help me.
the cell that I'm in needs to automatically put in both the username and the
date and time. I can do each one alone but not together. The closest that I
got is when the date came up the Excel way and not mm/dd/yyyy.
I had: =IF (B1=True, ThisUser() & " " & Now(), " ")
Please help me.