So I was given this formula from this online help (very grateful by the way,
thanks for the help!!):

=IF(A1="","", IF(B1="", NOW(), B1))

But the thing is, it is a shared workbook. So when I hit save on my
computer, it does not reflect the time that "cell A1" was originally entered,
but rather the time it showed up "updated" on my computer. How can I prevent
this from happening? Would it be easier to put in the worksheet_change event
that I've been reading about on this site? Whichever is simpler will do.
Thanks for all the help everyone.