| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formular | New Users to Excel | |||
| I still need help with formular? | Excel Worksheet Functions | |||
| formular | Setting up and Configuration of Excel | |||
| If formular | Excel Discussion (Misc queries) | |||
| Need Help With A Formular | New Users to Excel | |||
Linear Mode
