| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding days between cells C and L where the cells may be empty
Cells C8 and L8 represent entry and exit dates. I used the formula
=(L8-G8)/7 to find the number of weeks between the dates. This works when there are dates in cells C8 ands L8. However, when the cells do not contain dates, I get the VALVE error reading in the cell designated to show rthe number of weeks. How can I modify the formula to address instances when the cells will be left empty? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding days between cells C and L where the cells may be empty
Assuming you want some indication
=IF(OR(C8="",L8=""),"Dates incomplete",(L8-C8)/7) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jack" wrote in message ... Cells C8 and L8 represent entry and exit dates. I used the formula =(L8-G8)/7 to find the number of weeks between the dates. This works when there are dates in cells C8 ands L8. However, when the cells do not contain dates, I get the VALVE error reading in the cell designated to show rthe number of weeks. How can I modify the formula to address instances when the cells will be left empty? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I make a Chart data series treat blanks as "Empty" cells | Charts and Charting in Excel | |||
| Ignoring empty cells | Excel Discussion (Misc queries) | |||
| When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
| Trendlines to ignore empty cells | Charts and Charting in Excel | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
Linear Mode
