| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel automatically enter the date data in a cell was entered | Excel Worksheet Functions | |||
| formula to update todays date in excell automatically daily | New Users to Excel | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| In Excel, Get todays date in a cell | Excel Discussion (Misc queries) | |||
| Excel: How do I enter a date in one cell & automatically dates adj | Excel Discussion (Misc queries) | |||
Linear Mode
