Find Yearly Differences. “y” A difference in complete years. For an example let’s get the difference. Join Date Location Stockton Heath, Cheshire, UK MS-Off Ver Office 365, Excel for Windows 2010 & Excel for Mac Posts 26,902.
The english function name DATEDIF() has been translated into 15 languages. For all other languages, the english function name is used. There are some differences between the translations in different versions of Excel.
Availability
| Excel Versions | Availability | Category |
|---|---|---|
| Excel (Office 365) | Yes | Hidden |
| Excel 2013 | Yes | Hidden |
| Excel 2010 | Yes | Hidden |
| Excel 2007 | Yes | Hidden |
| Excel 2003 | Yes | Hidden |
Reference language
| Language | Designation |
|---|---|
| English | DATEDIF |
Translations
| Language | Designation |
|---|---|
| Basque | DATADIF |
| Catalan | DIFDATA |
| Danish | DATO.FORSKEL |
| Dutch | DATUMVERSCHIL |
| Finnish | PVMERO |
| Galician | DATADIF |
| Hungarian | DÁTUMTÓLIG |
| Italian | DATA.DIFF |
| Norwegian | DATODIFF |
| Polish | DATA.RÓŻNICA |
| Portuguese, Brazil | DATADIF |
| Portuguese, Portugal | DATADIF |
| Russian | РАЗНДАТ |
| Spanish | SIFECHA |
| Turkish | ETARİHLİ |
Links to the Microsoft Online Help for the function DATEDIF()
Bara no sabaku drama cd anime lek. Note: Microsoft is currently updating the links and contents for the Excel online help. Therefore, some of the following links may not work as expected and lead to an error page. The links will on this site will be updated as soon as possible.
Datedif Function Excel For Mac 2016 Free
| Language | |||
|---|---|---|---|
| Arabic | Finnish | Kazakh | Russian |
| Basque | French | Konkani | Serbian |
| Bulgarian | Galician | Korean | Slovak |
| Catalan | German | Latvian | Slovenian |
| Chinese - Simplified | Greek | Lithuanian | Spanish |
| Chinese - Traditional | Gujarati | Malaysian | Swedish |
| Croatian | Hebrew | Marathi | Thai |
| Czech | Hindi | Norwegian | Turkish |
| Danish | Hungarian | Polish | Ukrainian |
| Dutch | Indonesian | Portuguese, Brazil | Vietnamese |
| English | Italian | Portuguese, Portugal | - |
| Estonian | Japanese | Romanian | - |
LreAL wrote:
=DATEDIF(”04/06/1988”, NOW(), “Y”) & “ years, “ & DATEDIF(”04/06/1988”, NOW(), “YM”) & “ months, and “ & DATEDIF(”04/06/1988”, NOW(), “MD”) & “ days”
When looking for a syntax error, I often find it useful to break the formula down into its parts. To allow for different date formats (and different dates) with this one, I've also replaced the fixed date literal ('04/06/1988') with a cell reference, and placed the date in that cell.
=
DATEDIF(”04/06/1988”, NOW(), “Y”)
& “ years, “ &
DATEDIF(”04/06/1988”, NOW(), “YM”)
& “ months, and “ &
DATEDIF(”04/06/1988”, NOW(), “MD”)
& “ days”
That wasn't much help in this case, as each part of the formula looks correct.
So I decided to reconstruct the formula. I placed each DATEDIF statement into a separate cell on Row 2, placed the date in C2, and replaced the literal '04/06/1988' with a reference to C. All three parts worked flawlessly with either the literal or the reference to the cell in the same row of column C (which contained the date).
After removing all spaces that were not part of a literal text string (ie. that occurred outside pairs of quotation marks), I started adding the parts of the formula back on to the first part one line at a time, testing after each addition. The formula continued to work on each test, including a test of the final version below.
=DATEDIF(C, NOW(), 'Y')&' years, '&DATEDIF(C, NOW(), 'YM')&' months, and '&DATEDIF(C, NOW(), 'MD')&' days'
I also reinserted the spaces before and after the concatenation operator ( & ), and found their inclusion made no difference to the result.
So I don't know what was the syntax error, but did find that reconstructing the formula removed the error message and returned the correct result.
Regards,
Barry
Datedif Function Excel For Mac 2016 Free
May 24, 2010 11:39 PM