Hi,
see this one could be help..
On Thu, Feb 13, 2014 at 8:15 PM, Ahmed Honest wrote:
> Dear All,
>
> Please see below and kindly help.
>
> Requirement : How to get no. of years, months and Dates between 2 dates.
>
> Example :
> Start date : 1-Oct-2012 suppose in cell A1,
> End Date : 30-Jun-20
Hi,
See how is this attachment.. it could hep...
On Thu, Feb 13, 2014 at 8:15 PM, Ahmed Honest wrote:
> Dear All,
>
> Please see below and kindly help.
>
> Requirement : How to get no. of years, months and Dates between 2 dates.
>
> Example :
> Start date : 1-Oct-2012 suppose in cell
Thanks Ashish but Please observe my initial draft. Datedif I know very well
on the usage and it fails.
Regards
On Thu, Feb 13, 2014 at 5:58 PM, Ashish Kumar wrote:
> Hi Ahmed,
>
> PFA..!!!
>
>
> Thanks
> Ashish
>
>
>
> On 13 February 2014 20:15, Ahmed Honest wrote:
>
>> Dear All,
>>
>> Ple
Hi Ahmed,
PFA..!!!
Thanks
Ashish
On 13 February 2014 20:15, Ahmed Honest wrote:
> Dear All,
>
> Please see below and kindly help.
>
> Requirement : How to get no. of years, months and Dates between 2 dates.
>
> Example :
> Start date : 1-Oct-2012 suppose in cell A1,
> End Date : 30-Jun-
Dear All,
Please see below and kindly help.
Requirement : How to get no. of years, months and Dates between 2 dates.
Example :
Start date : 1-Oct-2012 suppose in cell A1,
End Date : 30-Jun-2013 suppose in cell B1
Then used formula is :
1. Datedif(a1,b1,"Y") for years = Output is zero
2. Datedif
