LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
report date - date rec.ved=days late, but how to rid dates complet MS Questionnairess Excel Worksheet Functions 3 January 25th 07 06:17 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
How do I flag a cell in Excel 2002 when the date entered has pass sas1950 Excel Discussion (Misc queries) 1 February 15th 06 04:52 PM
How do I flag a cell in Excel 2002 when the date entered has pass sas1950 Excel Discussion (Misc queries) 0 February 15th 06 04:20 PM
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. dencrowell Excel Discussion (Misc queries) 1 April 14th 05 04:11 AM


All times are GMT +1. The time now is 10:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"