Difference between two dates expressed as years, months, days (in one column)

by 
=IF(DATEDIF(A1, B1, "D")>365, QUOTIENT(DATEDIF(A1, B1, "D"), 365)&" year(s) "&
                          QUOTIENT(MOD(DATEDIF(A1, B1, "D"), 365), 30)&" month(s) "&
                      MOD(QUOTIENT(MOD(DATEDIF(A1, B1, "D"), 365), 30), 30)&" day(s)",
 IF(DATEDIF(A1, B1, "D")>30,  QUOTIENT(DATEDIF(A1, B1, "D"), 30)&" month(s) "&
                                   MOD(DATEDIF(A1, B1, "D"), 30)&" day(s)", 
                                       DATEDIF(A1, B1, "D")&" day(s)"))

0

More Related Contents:

  1. How to compare dates or date against today with query on google sheets?
  2. Change date format as dd/mm/yyyy in php [closed]
  3. ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
  4. How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
  5. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  6. Selecting the last value of a column
  7. ArrayFormula and “AND” Formula in Google Sheets
  8. Google Apps Script date format issue (Utilities.formatDate)
  9. ARRAY_LITERAL, an Array Literal was missing values for one or more rows
  10. Changing date format to “%d/%m/%Y”
  11. How to use arrayformula with formulas that do not seem to support arrayformulas?
  12. Google Sheets Formula for Extracting Domain From Website?
  13. In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
  14. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  15. Convert a date format in PHP [duplicate]
  16. How to format date and time in Android?
  17. `uuuu` versus `yyyy` in `DateTimeFormatter` formatting pattern codes in Java?
  18. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  19. PHP convert date format dd/mm/yyyy => yyyy-mm-dd [duplicate]
  20. Get the last non-empty cell in a column in Google Sheets
  21. Javascript library for human-friendly relative date formatting [closed]
  22. How to convert ISO Date to UTC date in Hive
  23. Using built-in spreadsheet functions in a script
  24. Determine season given timestamp in Python using datetime
  25. IMPORTXML and right XPath from Bloomberg price [duplicate]
  26. How to list all permutations without repetition?
  27. How to create all possible pair combinations without duplicates in Google Sheets?
  28. Compare two dates Google apps script
  29. How do I align date and values to gridlines in Google Chart?
  30. Same date in different time zone

Leave a Comment