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

T

theflyingtaz

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

FirstVette52

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


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

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
 
D

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. :)
 
F

FirstVette52

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


David Biddulph said:
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. :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top