file is not open
From: Chandra Gupta Maurya
To: excel-macros@googlegroups.com
Sent: Thursday, 4 July 2013 2:33 PM
Subject: Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
<>
<>
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http
, October 09, 2009 7:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Subtract dates
Interesting.
In Excel2007, there is no mention of it, and it is not available
in the function wizard.
Looking at the documentation link provided, it says it applies to:
Microsoft
e to use things like:
abs(date1-date2)
so, I learned something new today,
can I go home now?
thanks!
Paul
From: Aindril De
To: excel-macros@googlegroups.com
Sent: Friday, October 9, 2009 9:38:01 AM
Subject: $$Excel-Macros$$ Re: Subtract dates
Hi All,
There
<>
<>
lumn as dd-mm-yy. It should be
>> formatted as number.
>>
>> I never used Datediff and so was unaware that it is VBA only function but
>> *now* I know.
>>
>>
>>
>> Thanks,
>>
>> Upendra Singh
>>
>> +91-9910227325
>>
>&g
function but
> *now* I know.
>
>
>
> Thanks,
>
> Upendra Singh
>
> +91-9910227325
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Paul Schreiner
> *Sent:* Friday, October 09, 2009 5:23 PM
> *To:* excel-macros@go
<>
Upendra Singh would like to recall the message, "$$Excel-Macros$$ Re:
Subtract dates".
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutor
...@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: Friday, October 09, 2009 5:23 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Subtract dates
Hmm... I'm not sure I completely agree.
what you say at first is true, it is similar to subtracting numbers,
because:
Excel do
ot;YY-MM-DD" format.
But are you sure you WANT to?
Paul
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent: Friday, October 9, 2009 12:59:36 AM
Subject: $$Excel-Macros$$ Re: Subtract dates
Hi Huzaifa,
Yes, it is possible. It is similar as you subtr
Hi Huzaifa,
Yes, it is possible. It is similar as you subtract number in Excel, after
that you have to change the cell format to "YY-MM-DD" format.
Alternatively, you can also use DATEDIF function, to get the difference as
per your choice i.e. months, completed months, years etc.
--
DILIP KUMAR
Somehow if you have date in format hh:mm dd/mm/yy and you try to
subtract you may not get accurate results in such a case use the
following formula. Suppose your start time and date is in cell A1 and
end time and date in cell B1 in C1 type
=B1+ (A1>B1) - A1
Since on subtracting dates Excel doesn'
Hi Huzaifa,
This is very much possible to subtract dates. Simply subtract as you
subtract no.s and format the cell as "yy-mm-dd".
This works fine provided you are subtracting dates and not text written as
date.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From:
17 matches
Mail list logo
