Please can some one help see the table below the difference between dates should all be "0" I am using the formula =day(E2)-day(D2) for some it works others it does not. I have changed cells so that they are dates not numbers already but does not work. Might help to know the ones it does work for when I change the format of the cell to normal those that work turn to a number but the ones that don't work stay as a date regardless of if I select Normal date or whatever.
8/5/20138/5/2013024-07-201324/07/2013#VALUE!26-07-201326-07-2013#VALUE! 31/07/201331/07/2013#VALUE!2/8/20132/8/2013026/07/201326/07/2013#VALUE! 5/8/20135/8/2013026/07/201326/07/2013#VALUE! -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
