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
|