Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using Excel in Office 2003. My spreadsheet contains a column (H) of
dates in the following format "2-Feb-06." Another column (J) contains the formula =H3+10, for example. In other words I want column J to populate with dates 10 days past the dates entered in column H. In the above example, the cell J3 contains "12-Feb-06." This is working like a charm exept for instances in which the cell in column H is blank. When this happens the date "10-Jan-00" appears in column J because it is adding 10 days to nothing (empty cell). Is there any way I can utilize this formula to keep a cell in J blank if the corresponding cell in H is blank? Any help would be greatly appreciated! Thanks, Melissa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
continuing formula when cells are empty | Excel Worksheet Functions | |||
Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
Trendlines to ignore empty cells | Charts and Charting in Excel | |||
excluding cells from the formula when empty | Excel Worksheet Functions |