But as the OP wanted to "enter a date in a cell", I would have thought that
neither NOW() nor TODAY() was relevant.

I suppose it depends whether we are answering the question in the body of
the message, or the different question in the subject line. Questioners
please note. :-)
--
David Biddulph

"Peo Sjoblom" wrote in message
...
Since the OP wanted to enter a date it is probably better to use TODAY()
as opposed to NOW()

"FirstVette52" <(My User name is Firstvette 52, too) firstvet52@(my ISP
E-mail provider is) netzero.com wrote in message
...
Try this: =NOW()+45

"David Biddulph" wrote:

=A2+45
or, if you want the second cell to stay empty until the first one is
filled,
=IF(A2="","",A2+45)

"theflyingtaz" wrote in message
...
Can I enter a date in a cell and have the cell next to it
automatically
fill
with a date 45 days later?