Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
I am adding two cells togetgher that contains dates to find the number of
actual days between them. The formula i am using is =I21-H21+1 quiet simple, but on the empty cells i have default fig of 1 showing. Is there any way i can remove this for a zero fig. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200605/1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Try this:
=IF(OR(I21="",H21=""),0,I21-H21+1) If either I21 or H21 (or both) are blank, then return a zero, otherwise your formula. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Pete_UK wrote:
Try this: =IF(OR(I21="",H21=""),0,I21-H21+1) If either I21 or H21 (or both) are blank, then return a zero, otherwise your formula. Hope this helps. Pete Thank you for this and it worked well. Again thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200605/1 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula
Thanks for feeding back - glad it worked for you.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |