Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculating dates
What formula do i use???
here is my problem... i have 3 columns A- Qty of days eg: 6, B-start date, eg: 10/12/07 C -end date, , (formula i am using, (colummn (C) =A+B+1 (copied down the column) this gives me an end date by adding A and B which i use in a gantt chart, eg; "but" some dates do not have a start date yet and the end result will read (C) 05/01/00, how can i get column (C) to remain blank until i put a start date in???? |
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 dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
calculating with dates | Excel Worksheet Functions |