Access, Access 2007, Access query, Browsers, Desktop management applications, Desktops, Domain management, Enterprise Desktop, excel, Excel 2003, Excel 2007, GPO, Group Policy, HP, IIS, Installation, Internet Explorer, Microsoft, Microsoft Access 2007, Microsoft Excel, Microsoft Office, Microsoft Office 2007, Microsoft Word, Migration, Office 2003, Office 2007, OS, PC/Windows Connectivity, PDF, Printers, Printing, Scripting, Shared folders, SharePoint, Training, Vista, Vista compatibility, Windows, Windows 7, Windows 7 Administration, Windows 7 in 2010, Windows 7 Professional, Windows errors, Windows Vista, Windows XP, Windows XP administration, Windows XP Pro, Windows XP Professional, Windows XP SP3, Word 2007 VIEW ALL TAGS
I want to subtract two cells in excel but only if both cells have a value. For instance, the formula I am using is thus: F2 is currently =E2-D2 but I only want this to be calculated when E2 has a value.
In my program I pass values from VB to Excel for reporting. When I pass 03-01-2009 (3rd Jan 2009), in excel it shows as 01-03-2009. I have set short date format to dd-mm-yyyy, in control panel, regional settings. Also in excel, I set cell format through VB as ... ...