| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
How does that work?
=DATEDIF(3/31/2006,5/31/2006,"m") = 2 How can I get Excel to count exactly one month between the dates 3/31/2006 and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.? Dave -- Brevity is the soul of wit. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
=DATEDIF(DATEVALUE("3/31/2006"),DATEVALUE("5/31/2006"),"m")
What you have is equivalent to =DATEDIF(0.000048242369665198,0.000080403949441996 6,"m") -- Regards, Tom Ogilvy "Dave F" wrote in message ... How does that work? =DATEDIF(3/31/2006,5/31/2006,"m") = 2 How can I get Excel to count exactly one month between the dates 3/31/2006 and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.? Dave -- Brevity is the soul of wit. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
Hi Dave
Slightly easier when dates are in cells =DATEDIF(A1,B1,"m")+(DAY(A1)DAY(B1)) -- Regards Roger Govier "Dave F" wrote in message ... How does that work? =DATEDIF(3/31/2006,5/31/2006,"m") = 2 How can I get Excel to count exactly one month between the dates 3/31/2006 and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.? Dave -- Brevity is the soul of wit. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
=DATEDIF(DATEVALUE("3/31/2006"),DATEVALUE("5/31/2006"),"m")
No need for Datevalue: =DATEDIF("3/31/2006","5/31/2006","m") Biff "Tom Ogilvy" wrote in message ... =DATEDIF(DATEVALUE("3/31/2006"),DATEVALUE("5/31/2006"),"m") What you have is equivalent to =DATEDIF(0.000048242369665198,0.000080403949441996 6,"m") -- Regards, Tom Ogilvy "Dave F" wrote in message ... How does that work? =DATEDIF(3/31/2006,5/31/2006,"m") = 2 How can I get Excel to count exactly one month between the dates 3/31/2006 and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.? Dave -- Brevity is the soul of wit. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
=DATEDIF(3/31/2006,4/30/2006,"m") equals 0?
If someone said to me on March 31st "I'll see you in a months time." I would
not know for sure what they meant. Why should Excel be any different? "Dave F" wrote in message ... How does that work? =DATEDIF(3/31/2006,5/31/2006,"m") = 2 How can I get Excel to count exactly one month between the dates 3/31/2006 and 4/30/2006, or between 4/30/2006 and 5/31/2006, etc.? Dave -- Brevity is the soul of wit. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| equals something | Excel Discussion (Misc queries) | |||
| add one cell with no equals operator | Excel Discussion (Misc queries) | |||
| how to run a macro when a calculation equals a certin number | Excel Worksheet Functions | |||
| Apostrophes instead of equals in Excel | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Linear Mode
