| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Calculations before date entered
I am creating a chart, that adds a varying number of days as you go across
the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
Surround your calculations in an If statement, as in
=if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to
that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you lay this out in, umm, simple terms? Thanks so much for your help. "Fred Smith" wrote: Surround your calculations in an If statement, as in =if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
Hi,
=IF(B5="","",B5+5) =IF(B5="","",B5+13) it simply states that if B5 is blank (represented by the double quotes) then show blank. Hope this helps! Jean-Guy "Ma2Weir" wrote: Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you lay this out in, umm, simple terms? Thanks so much for your help. "Fred Smith" wrote: Surround your calculations in an If statement, as in =if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
Not knowing what "etc." entails it is hard to say what you need.
In F5 enter =$B$5 + 5 In G5 enter =E5 + 8 What goes into H5 is up to the terms of "etc." Gord Dibben MS Excel MVP On Wed, 31 Jan 2007 17:15:00 -0800, Ma2Weir wrote: Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you lay this out in, umm, simple terms? Thanks so much for your help. "Fred Smith" wrote: Surround your calculations in an If statement, as in =if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
It worked!! Thank you, thank you, thank you. Now is there a shortcut to
replicate that throughout the sheet for each row? Or do I need to type in each individually? Thanks again! This has been driving me bonkers! Ma2Weir "pinmaster" wrote: Hi, =IF(B5="","",B5+5) =IF(B5="","",B5+13) it simply states that if B5 is blank (represented by the double quotes) then show blank. Hope this helps! Jean-Guy "Ma2Weir" wrote: Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you lay this out in, umm, simple terms? Thanks so much for your help. "Fred Smith" wrote: Surround your calculations in an If statement, as in =if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
Hi,
You can copy the formulas down by grabbing the small black square in the bottom right corner of the cell then drag down as far as needed or you can copy it then paste it into the cells you want. Note that if you need to paste it into different columns but want to keep the reference to B5 then you will have to make the reference to B5 absolute by putting a dollar sign ($) in front of the letter B. =IF($B5="","",$B5+5) that way the reference to the column B won't change but the reference to the row will when dragged down. HTH Jean-Guy "Ma2Weir" wrote: It worked!! Thank you, thank you, thank you. Now is there a shortcut to replicate that throughout the sheet for each row? Or do I need to type in each individually? Thanks again! This has been driving me bonkers! Ma2Weir "pinmaster" wrote: Hi, =IF(B5="","",B5+5) =IF(B5="","",B5+13) it simply states that if B5 is blank (represented by the double quotes) then show blank. Hope this helps! Jean-Guy "Ma2Weir" wrote: Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you lay this out in, umm, simple terms? Thanks so much for your help. "Fred Smith" wrote: Surround your calculations in an If statement, as in =if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
Once again, I thank you. I now have my worksheet the way I needed it and can
go to sleep without it circling my brain. Thanks again, this was a wonderful resource and one I hope to use again. Ma2weir "pinmaster" wrote: Hi, You can copy the formulas down by grabbing the small black square in the bottom right corner of the cell then drag down as far as needed or you can copy it then paste it into the cells you want. Note that if you need to paste it into different columns but want to keep the reference to B5 then you will have to make the reference to B5 absolute by putting a dollar sign ($) in front of the letter B. =IF($B5="","",$B5+5) that way the reference to the column B won't change but the reference to the row will when dragged down. HTH Jean-Guy "Ma2Weir" wrote: It worked!! Thank you, thank you, thank you. Now is there a shortcut to replicate that throughout the sheet for each row? Or do I need to type in each individually? Thanks again! This has been driving me bonkers! Ma2Weir "pinmaster" wrote: Hi, =IF(B5="","",B5+5) =IF(B5="","",B5+13) it simply states that if B5 is blank (represented by the double quotes) then show blank. Hope this helps! Jean-Guy "Ma2Weir" wrote: Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you lay this out in, umm, simple terms? Thanks so much for your help. "Fred Smith" wrote: Surround your calculations in an If statement, as in =if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Calculations before date entered
You're quite welcome.....glad I could help!
Jean-Guy "Ma2Weir" wrote: Once again, I thank you. I now have my worksheet the way I needed it and can go to sleep without it circling my brain. Thanks again, this was a wonderful resource and one I hope to use again. Ma2weir "pinmaster" wrote: Hi, You can copy the formulas down by grabbing the small black square in the bottom right corner of the cell then drag down as far as needed or you can copy it then paste it into the cells you want. Note that if you need to paste it into different columns but want to keep the reference to B5 then you will have to make the reference to B5 absolute by putting a dollar sign ($) in front of the letter B. =IF($B5="","",$B5+5) that way the reference to the column B won't change but the reference to the row will when dragged down. HTH Jean-Guy "Ma2Weir" wrote: It worked!! Thank you, thank you, thank you. Now is there a shortcut to replicate that throughout the sheet for each row? Or do I need to type in each individually? Thanks again! This has been driving me bonkers! Ma2Weir "pinmaster" wrote: Hi, =IF(B5="","",B5+5) =IF(B5="","",B5+13) it simply states that if B5 is blank (represented by the double quotes) then show blank. Hope this helps! Jean-Guy "Ma2Weir" wrote: Ooookaay. I am a baby at this. B5 has todays date. I want to add 5 days to that date for cell F5, 13 days to the date in B5 for cell G5 etc. COuld you lay this out in, umm, simple terms? Thanks so much for your help. "Fred Smith" wrote: Surround your calculations in an If statement, as in =if(a1="","",.....) -- Regards, Fred "Ma2Weir" wrote in message ... I am creating a chart, that adds a varying number of days as you go across the chart. I have entered formulas to add, and it works fine. EXCEPT...when there is no starting date entered, all boxes are filled with data. I know it adds from 01/01/00, but really don't want to see all these nonsensical dates. I want a clean sheet that data shows up when I enter the baseline cell data. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
| Mileage Claim Formula | New Users to Excel | |||
| How do I flag a cell in Excel 2002 when the date entered has pass | Excel Discussion (Misc queries) | |||
| How do I flag a cell in Excel 2002 when the date entered has pass | Excel Discussion (Misc queries) | |||
| FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
Linear Mode
