Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2007

Tip: Looking for answers? Try searching our database.

CALCULATING DATES

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
spudpeeps - 05 Dec 2007 10:14 GMT
can anyone help me! i have created a gantt chart, but having the following
problem: column A contains qty of days, column B is start date, column C is
end date. i have set column C so that it adds column A + column B to give me
an end date, but if there is no start date, the end date displays 05/01/00.
      A        B                 C
E.g: 6 + (05/12/07) = 10/12/07   ( formula i am using or (C ) is  =A+B+1)
      6 + (            ) = 05/01/00  ( i want this to remain blank until i
put a start date
in as i have copied the formula down the cells of column C
any ideas???
WLMPilot - 05 Dec 2007 12:23 GMT
Change the formula in C1 to the following:

=IF(B1="","",A1+B1+1)

Then copy and paste down column C as far as you need it.

> can anyone help me! i have created a gantt chart, but having the following
> problem: column A contains qty of days, column B is start date, column C is
[quoted text clipped - 6 lines]
> in as i have copied the formula down the cells of column C
> any ideas???
spudpeeps - 05 Dec 2007 14:45 GMT
> Change the formula in C1 to the following:
>
[quoted text clipped - 12 lines]
> > in as i have copied the formula down the cells of column C
> > any ideas???
thank you so much
although this solved the above problem, it has now caused another problem,
my fault i did not say what i was working on, i have created a gantt chart
in excel
and use the start and end dates to calculate work progress and for every day
counted in the end date, a designated cell will be highlited through out the
month.
the above formula you have sent has caused the whole of the month to be
highlited,
what i want is for the whole range of cells for that month to also remain
blank until the start date is entered.....
WLMPilot - 06 Dec 2007 11:40 GMT
Still not sure what you are trying to do.  Can you explain the "range of
cells" by using cell examples and what they are to do.  I may be able to help
you better then.
Also, explain your original formula:  What is the qty of days and how do you
determine that value.  Also, why is "1" added to the formula?

Thanks,
Les

> > Change the formula in C1 to the following:
> >
[quoted text clipped - 23 lines]
> what i want is for the whole range of cells for that month to also remain
> blank until the start date is entered.....

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.