Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between dates
Please help, I am calculating the difference between two dates, =IF(Q101,Q10-E10,"") but if one of the cells is empty it's showing #VALUE!. Is there a way to stop this happening. Many thanks -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=545642 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between dates
I used your formula and did not have your problem.
If Q10 is blank, then from your formula, the results is ""; If E10 is blank, then it returns the date value of the date in Q10. IF both are blank, it also returns "". If you still have the problem, then try this: = if(iserror(yourformula), "", yourformula) replace yourformula in above with IF(Q101,Q10-E10,"") -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "Clash" wrote in message ... Please help, I am calculating the difference between two dates, =IF(Q101,Q10-E10,"") but if one of the cells is empty it's showing #VALUE!. Is there a way to stop this happening. Many thanks -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=545642 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between dates
Hope this helps:
=IF(AND(ISNUMBER(Q10),ISNUMBER(E10),Q101),Q10-E10,"") ed |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between dates
Do you have formulas in E10 and Q10? -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=545642 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between dates
daddylonglegs Wrote: Do you have formulas in E10 and Q10? Sorry I didn't say. Yes, they are to formulas, the two dates are pulled thru from two different spreadsheets. -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=545642 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
difference between dates | Excel Discussion (Misc queries) | |||
I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) | |||
Difference betn 2 Dates | Excel Discussion (Misc queries) | |||
How do I calculate the difference between 2 dates (m,d,y) ? | Excel Worksheet Functions |