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???? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculating dates
=IF(A1="","",A1+B1+1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "spudpeeps" wrote in message ... | 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???? | |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
calculating dates
Niek's formula references A1, should be B1. If your chart uses all of column
C, you may need to use this formula to prevent blanks from showing up in your chart. =IF(B1="",NA(),A1+B1+1) -- Best Regards, Luke M "spudpeeps" wrote: 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???? |
Reply |
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 |