$$Excel-Macros$$ Date Substraction

2013-12-01 Thread Shrinivas Shevde
Dear all I want to subtract one date from another (file attached ) Can anyone help me I think for the date format is not same Regards Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Date Substraction

2013-12-01 Thread Sam Mathai Chacko
Srini, are you looking to subtract dates in column C from column B or vice versa, ie, B-C or C-B? In addition, some values are coming as #N/A. What to do with those? Regards, Sam Mathai Chacko On Sun, Dec 1, 2013 at 3:57 PM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear all I want to

Re: $$Excel-Macros$$ Date Substraction

2013-12-01 Thread Shrinivas Shevde
Dear Sam, Thanks for reply I want to substract from Column c To column B i e B-C,Forget about #N/A Regards Shrinivas On Sun, Dec 1, 2013 at 10:11 PM, Sam Mathai Chacko samde...@gmail.comwrote: Srini, are you looking to subtract dates in column C from column B or vice versa, ie, B-C or C-B?