Try
a1B1c1
1-Jan-04 31-Mar-04 0 2-Jan-04 1-Apr-05 1 2
[c1] =DATEDIF(A1, B1, "Y")
On Sun, Sep 21, 2008 at 9:57 AM, vivek jain <[EMAIL PROTECTED]> wrote:
>
>
> Dear All,
> I am preparing a fixed asset register for the last fifty years for an
> organi
Use the formula,
=IF(A1>DATE(2004,3,31),0,IF(YEAR(DATE(2004,3,31))-YEAR(A1)=0,1,YEAR(DATE(2004,3,31))-YEAR(A1)))
instead of yours.
Regards,
Ajit
On Sun, Sep 21, 2008 at 12:26 PM, Balachander S <[EMAIL PROTECTED]> wrote:
> Try
>a1B1c1
>1-Jan-04 3
Hi Ajit,
a) convert both the number in date format...
b) Substract the dates and divide by 365/366 as the case be.
I hope that solves your problem.
On 9/22/08, AJIT NAVRE <[EMAIL PROTECTED]> wrote:
>
> Use the formula,
>
>
> =IF(A1>DATE(2004,3,31),0,IF(YEAR(DATE(2004,3,31))-YEAR(A1)=0,1,YEAR
Thanks.
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of AJIT NAVRE
Sent: Monday, September 22, 2008 11:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO
DATES
Use the formula,
=IF(A1>DATE(2004,3
Hi everybody,
I tried using the DateDif function in Ms-Office 2007 but its not
working. Is there any other way to activate the function since i heard that
the function is hidden in Excel by Microsoft co.
Thanks,
Augustine
On Sun, Sep 21, 2008 at 12:26 PM, Balachander S <[EMAIL PROTECTED]> wr
try using days360() instead.
On Mon, Oct 6, 2008 at 6:06 PM, Augustine <[EMAIL PROTECTED]> wrote:
> Hi everybody,
>
>I tried using the DateDif function in Ms-Office 2007 but its not
> working. Is there any other way to activate the function since i heard that
> the function is hidden in Exce
It would be ideal to use datedif formula like this
C1 =DATEDIF(A1-1, B1, "Y") . For instance if your start date is 1-Jan-04 &
end date is 31-Dec04 then datedif (without -1) will give you 0 as years
where as you are expecting answer 1.. :)
Regards
Subu
This will take care of the days issues
On M
Hi Augustine,
You can use "=DAYS360(Start_date,End_date)/360"
Good Luck,
ASD
2008/10/6 Augustine <[EMAIL PROTECTED]>
Hi everybody,
I tried using the DateDif function in Ms-Office 2007 but its not working.
Is there any other way to activate the function since i heard that the
f
Hi subu,
thanks, I did not know till now that Excel has a function called DateDif(),
probably because it is not documented after Excel 2000. Anyways, thanks.
Ajit
On Tue, Oct 7, 2008 at 7:23 AM, Subu <[EMAIL PROTECTED]> wrote:
> It would be ideal to use datedif formula like this
> C1 =DATEDIF(A1
pls chk formula in atached file
Thanks & Regards
Harish Upadhyay
On 10/6/08, Augustine <[EMAIL PROTECTED]> wrote:
>
> Hi everybody,
>
>I tried using the DateDif function in Ms-Office 2007 but its not
> working. Is there any other way to activate the function since i heard that
> the functi
10 matches
Mail list logo