Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CALCULATING DATES
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??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating due dates | Excel Discussion (Misc queries) | |||
Calculating with dates | Excel Discussion (Misc queries) | |||
Calculating With Dates | Excel Discussion (Misc queries) | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |