| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula: count if not blank
I have two columns, a date in the left, and in the right a formula to
calculate the date plus 14 days. For some of the cells in the left column, there won't be a date right away. I want to have the formula to calcualte the date in all the cells in the right column so when i do enter a date in the left, it just pops up the correct date in the right column. How do i write the forumula so that it does not try to calculate the blank cells? Right now it gives me a date of 1/14 as the calculation from the blank cells. Thank you! -- C. Daniels |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula: count if not blank
=IF(A1="","",A1+14)
"cdaniels" wrote: I have two columns, a date in the left, and in the right a formula to calculate the date plus 14 days. For some of the cells in the left column, there won't be a date right away. I want to have the formula to calcualte the date in all the cells in the right column so when i do enter a date in the left, it just pops up the correct date in the right column. How do i write the forumula so that it does not try to calculate the blank cells? Right now it gives me a date of 1/14 as the calculation from the blank cells. Thank you! -- C. Daniels |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Unique Values | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Array formula returns blank in the cell where it is entered | Excel Worksheet Functions | |||
| how can I count blank cells as a zero, when using formula please?? | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Linear Mode
