| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Month and Days question
Hi
This is my 'small' query If: - A1=22/8/2004 B1=31/12/2004 How can I display C1 as "4 months and 9 days" TIA |
|
#2
|
|||
|
|||
|
On Tue, 22 Feb 2005 03:59:04 -0800, "Anthony Slater"
wrote: Hi This is my 'small' query If: - A1=22/8/2004 B1=31/12/2004 How can I display C1 as "4 months and 9 days" TIA =DATEDIF(A1,B1,"m")&" months and " & DATEDIF(A1,B1,"md") & " days" See http://www.cpearson.com/excel/datedif.htm for documentation of this built-in Excel function. --ron |
|
#3
|
|||
|
|||
|
Ron
Thanks mate, that worked a treat "Ron Rosenfeld" wrote: On Tue, 22 Feb 2005 03:59:04 -0800, "Anthony Slater" wrote: Hi This is my 'small' query If: - A1=22/8/2004 B1=31/12/2004 How can I display C1 as "4 months and 9 days" TIA =DATEDIF(A1,B1,"m")&" months and " & DATEDIF(A1,B1,"md") & " days" See http://www.cpearson.com/excel/datedif.htm for documentation of this built-in Excel function. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of days in given month? | Excel Worksheet Functions | |||
| Summarizing of columns for different days of month | Excel Discussion (Misc queries) | |||
| I need to create pivot table for the month but data in days | Excel Discussion (Misc queries) | |||
| How to Set a fix # of days per month | Excel Worksheet Functions | |||
| Days of the Month | Excel Worksheet Functions | |||
Hybrid Mode
