Mukeshji, 1. What do you mean by H1 and H2 - these are cell references or string values?
2. Does the cell K8 contain date difference? 3. There's no function in Excel called DATEDIF, you can get the difference in two dates by subtracting them. It would be better understood if you can give an example of what you want to achieve. Best Regards, Zujar… An optimist laughs to forget and a pessimist forgets to laugh! -----Original Message----- From: AccessIndia [mailto:[email protected]] On Behalf Of Mukesh Sent: Thursday, April 04, 2013 7:29 AM To: Access India Subject: [AI] Formula correction Dear Friends, I have created a formula for my database. It is giving partial result. I want to modify it for better output. My condition is as follows: If cell j8= h1 then the formula should minus 0.5 from date difference in cell k8. If cell j8= h2 then the formula should minus 0.5 from date difference in cell k8. If cell j8= - then the formula should remain unchanged. My formula is as follows: =(IF(H8="-",0,IF(I8="-",0,IF(H8="",0,IF(I8="",0,IF(J8="h1",DATEDIF(H8,I8,"d")+1)-0.5))))) It’s very urgent to complete my database so please modify it for me today. Waiting for corrected formula. Thank you. Regards Mukesh Baviskar Mobile: 9403161157 Skype id: mukeshbaviskar Blog: http://mukeshbaviskar.blogspot.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
