Can I automatically have a cell enter todays date + 45 dyas

[theflyingtaz]

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

 

[David Biddulph]

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

 

[FirstVette52]

Try this: =NOW()+45
--
FirstVette52

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

 

[Peo Sjoblom]

Since the OP wanted to enter a date it is probably better to use TODAY() as
opposed to NOW()


--


Regards,


Peo Sjoblom



"FirstVette52" <(My User name is Firstvette 52, too) firstvet52@(my ISP
E-mail provider is) netzero.com> wrote in message

 

[David Biddulph]

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.

 

[FirstVette52]

Y'all 'think' too much ; )
--
FirstVette52

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.