Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: How do I enter a date in one cell & automatically dates adj
In excel, I am trying to find a formula or funtion so that when I enter a
date (1/10/05) in cell A1 for example, then B1 automatically changes to 1/11/05, C1 to 1/12/05, etc. Can anyone help? Thanks!! |
#2
|
|||
|
|||
In cell B1 your formula is
=A1+1 That will advance the date by one day. Copy that formula across, and you're good to go. |
#3
|
|||
|
|||
Hi Dave O, Thank you so much! Here's another question that has developed
after I entered that formula. Before I have a date in A1, B1 states "1/1/1900", C1 states "1/2/1900"; but it works perfectly once I enter a date in A1. I'm trying to create a timesheet template and don't want 1/1/1900 etc to be confusing. Is there a way that until I have a date in A1, nothing will show up in B1, C1, etc.? Thanks again. -Shannon "Dave O" wrote: In cell B1 your formula is =A1+1 That will advance the date by one day. Copy that formula across, and you're good to go. |
#4
|
|||
|
|||
Shannon
In B1 enter =IF($A$1="","",A1 + 1) Drag/copy across row 1 Gord Dibben Excel MVP On Tue, 11 Jan 2005 15:55:02 -0800, "Shannon" wrote: Hi Dave O, Thank you so much! Here's another question that has developed after I entered that formula. Before I have a date in A1, B1 states "1/1/1900", C1 states "1/2/1900"; but it works perfectly once I enter a date in A1. I'm trying to create a timesheet template and don't want 1/1/1900 etc to be confusing. Is there a way that until I have a date in A1, nothing will show up in B1, C1, etc.? Thanks again. -Shannon "Dave O" wrote: In cell B1 your formula is =A1+1 That will advance the date by one day. Copy that formula across, and you're good to go. |
#5
|
|||
|
|||
Perfect! Thanks!!
"Gord Dibben" wrote: Shannon In B1 enter =IF($A$1="","",A1 + 1) Drag/copy across row 1 Gord Dibben Excel MVP On Tue, 11 Jan 2005 15:55:02 -0800, "Shannon" wrote: Hi Dave O, Thank you so much! Here's another question that has developed after I entered that formula. Before I have a date in A1, B1 states "1/1/1900", C1 states "1/2/1900"; but it works perfectly once I enter a date in A1. I'm trying to create a timesheet template and don't want 1/1/1900 etc to be confusing. Is there a way that until I have a date in A1, nothing will show up in B1, C1, etc.? Thanks again. -Shannon "Dave O" wrote: In cell B1 your formula is =A1+1 That will advance the date by one day. Copy that formula across, and you're good to go. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Inserting the date that an excel sheet is saved into a cell | Excel Discussion (Misc queries) | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |