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

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

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

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

"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?

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

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


"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)
--
David Biddulph

"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?

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

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
...
Try this: =NOW()+45
--
FirstVette52


"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)
--
David Biddulph

"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?

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

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?

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

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


"David Biddulph" wrote:

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?