Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Buchup tape rotation
I am trying to put together a simple three column spreadsheet. Column A is a
tape number, column C is the date that the tape was last used for a backup and column E is the date that the tape will be available for use again. There is a 45 day spread between the two dates. What I want to do is when a date is entered into column C a return date automatically fills in column E. For example; a tape was unloaded on 11/23/09 and that date is entered into column C. Column E should then show a return date of 1/7/10. I have tried several different solutions and I keep getting an error message for a bad formula. Can somebody please help me? -- Nelson |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Buchup tape rotation
hi
what have you tried so far??? seem like a simple add 45 days to previous date should do it. with the data in c2, in e2, enter =C2+45 regards FSt1 "Nelson" wrote: I am trying to put together a simple three column spreadsheet. Column A is a tape number, column C is the date that the tape was last used for a backup and column E is the date that the tape will be available for use again. There is a 45 day spread between the two dates. What I want to do is when a date is entered into column C a return date automatically fills in column E. For example; a tape was unloaded on 11/23/09 and that date is entered into column C. Column E should then show a return date of 1/7/10. I have tried several different solutions and I keep getting an error message for a bad formula. Can somebody please help me? -- Nelson |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Buchup tape rotation
Hi Nelson, I have just put up a worked example for you at:-
http://www.pierrefondes.com/ - number 19 at the top of the page. Check out row 24 where you can see your specific example. If my comments have helped please hit Yes. Thanks. "Nelson" wrote: I am trying to put together a simple three column spreadsheet. Column A is a tape number, column C is the date that the tape was last used for a backup and column E is the date that the tape will be available for use again. There is a 45 day spread between the two dates. What I want to do is when a date is entered into column C a return date automatically fills in column E. For example; a tape was unloaded on 11/23/09 and that date is entered into column C. Column E should then show a return date of 1/7/10. I have tried several different solutions and I keep getting an error message for a bad formula. Can somebody please help me? -- Nelson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Buchup tape rotation
Thank you to both of you for the info. The formula works but unless there is
info in column 'C' I get either '# VALUE' or '14-Feb-00' in column E. I am using Office 2007, if that makes a difference. Is there any way that I can enter the formula into all of the cells in column E and not get an error message if there is no info(date) in column C ? -- Nelson "trip_to_tokyo" wrote: Hi Nelson, I have just put up a worked example for you at:- http://www.pierrefondes.com/ - number 19 at the top of the page. Check out row 24 where you can see your specific example. If my comments have helped please hit Yes. Thanks. "Nelson" wrote: I am trying to put together a simple three column spreadsheet. Column A is a tape number, column C is the date that the tape was last used for a backup and column E is the date that the tape will be available for use again. There is a 45 day spread between the two dates. What I want to do is when a date is entered into column C a return date automatically fills in column E. For example; a tape was unloaded on 11/23/09 and that date is entered into column C. Column E should then show a return date of 1/7/10. I have tried several different solutions and I keep getting an error message for a bad formula. Can somebody please help me? -- Nelson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Buchup tape rotation
=IF(C2="","",C2+45) entered in E2
Drag/copy down as far as you wish. Gord Dibben MS Excel MVP On Wed, 16 Dec 2009 11:31:01 -0800, Nelson wrote: Thank you to both of you for the info. The formula works but unless there is info in column 'C' I get either '# VALUE' or '14-Feb-00' in column E. I am using Office 2007, if that makes a difference. Is there any way that I can enter the formula into all of the cells in column E and not get an error message if there is no info(date) in column C ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
## Rabbi caught on tape with 17 stripper hidden video | Excel Worksheet Functions | |||
NC tape conversion | Excel Discussion (Misc queries) | |||
Tape recording time code? | Excel Discussion (Misc queries) | |||
Created date in "General" tape and "Statistics" tape | Excel Discussion (Misc queries) | |||
Formating fractions so they read like a measuring tape | Excel Discussion (Misc queries) |