formular discrepencies
 

Can anyone tell me why these two formulas give two different results? Can you
fix the discrepancy of three days

=IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" )
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)

=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146

formular discrepencies
 

DAYS360 is based on a 360 day year, 12 months * 30 days per month.

DATEDIF is based on a 365/366 day year.

--
Biff
Microsoft Excel MVP


"aussiegirlone" wrote in message
...
Can anyone tell me why these two formulas give two different results? Can
you
fix the discrepancy of three days

=IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" )
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)

=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146

formular discrepencies
 

And of course =TODAY()-L2 (if formatted as General or Number) gives the same
result as =DATEDIF(L2,TODAY(),"d")
--
David Biddulph

"T. Valko" wrote in message
...
DAYS360 is based on a 360 day year, 12 months * 30 days per month.

DATEDIF is based on a 365/366 day year.
--
Biff
Microsoft Excel MVP

"aussiegirlone" wrote in message
...
Can anyone tell me why these two formulas give two different results? Can
you
fix the discrepancy of three days

=IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" )
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)

=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146

formular discrepencies
 

Thank you for that, as it was something I had overlooked.That means to have a
365/366 day formular I would need to do this?
=IF(G6=C6,IF(AND(G60,C60),DAYS360(G6,C6)-6))

"David Biddulph" wrote:

And of course =TODAY()-L2 (if formatted as General or Number) gives the same
result as =DATEDIF(L2,TODAY(),"d")
--
David Biddulph

"T. Valko" wrote in message
...
DAYS360 is based on a 360 day year, 12 months * 30 days per month.

DATEDIF is based on a 365/366 day year.
--
Biff
Microsoft Excel MVP

"aussiegirlone" wrote in message
...
Can anyone tell me why these two formulas give two different results? Can
you
fix the discrepancy of three days

=IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" )
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)

=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146

formular discrepencies
 

I obviously overlooked the 360day formular and I think I found how to turn
that formular into a 366days which would look like this I guess
=IF(G6=C6,IF(AND(G60,C60),DAYS360(G6,C6)-6))

"T. Valko" wrote:

DAYS360 is based on a 360 day year, 12 months * 30 days per month.

DATEDIF is based on a 365/366 day year.

--
Biff
Microsoft Excel MVP


"aussiegirlone" wrote in message
...
Can anyone tell me why these two formulas give two different results? Can
you
fix the discrepancy of three days

=IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" )
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)

=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146

formular discrepencies
 

Throw away the DAYS360 function. You don't need it. Instead of
DAYS360(Q2,Q1) in your original formula, use Q2-Q1.
--
David Biddulph

"aussiegirlone" wrote in message
...
Thank you for that, as it was something I had overlooked.That means to
have a
365/366 day formular I would need to do this?
=IF(G6=C6,IF(AND(G60,C60),DAYS360(G6,C6)-6))

"David Biddulph" wrote:

And of course =TODAY()-L2 (if formatted as General or Number) gives the
same
result as =DATEDIF(L2,TODAY(),"d")
--
David Biddulph

"T. Valko" wrote in message
...
DAYS360 is based on a 360 day year, 12 months * 30 days per month.

DATEDIF is based on a 365/366 day year.
--
Biff
Microsoft Excel MVP

"aussiegirlone" wrote in
message
...
Can anyone tell me why these two formulas give two different results?
Can
you
fix the discrepancy of three days

=IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" )
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)

=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146

formular discrepencies
 

Crikey david, thats what I like, its short, it's simple, and straight to the
point LOL,
thank you
aussiegirlone.

"David Biddulph" wrote:

Throw away the DAYS360 function. You don't need it. Instead of
DAYS360(Q2,Q1) in your original formula, use Q2-Q1.
--
David Biddulph

"aussiegirlone" wrote in message
...
Thank you for that, as it was something I had overlooked.That means to
have a
365/366 day formular I would need to do this?
=IF(G6=C6,IF(AND(G60,C60),DAYS360(G6,C6)-6))

"David Biddulph" wrote:

And of course =TODAY()-L2 (if formatted as General or Number) gives the
same
result as =DATEDIF(L2,TODAY(),"d")
--
David Biddulph

"T. Valko" wrote in message
...
DAYS360 is based on a 360 day year, 12 months * 30 days per month.

DATEDIF is based on a 365/366 day year.
--
Biff
Microsoft Excel MVP

"aussiegirlone" wrote in
message
...
Can anyone tell me why these two formulas give two different results?
Can
you
fix the discrepancy of three days

=IF(Q2=Q1,IF(AND(Q20,Q10),DAYS360(Q2,Q1),""),"" )
Tuesday, 1 July 2008
Monday, 24 November 2008
(143)

=DATEDIF(L2,TODAY(),"d")
Tuesday, 1 July 2008
146