Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Datedif function for mm/dd/yyyy (https://www.askmehelpdesk.com/showthread.php?t=442118)

  • Feb 2, 2010, 01:42 AM
    santoshdream
    Datedif function for mm/dd/yyyy
    =DATEDIF(A1,TODAY(), "y").

    if Cell A1 = 08/15/1947 (MM/DD/YY Format)
    I want to calculate the exact month. Above function is not working. Please help.
  • Feb 2, 2010, 10:14 AM
    JBeaucaire

    The formula you've shown is set to show YEAR differences, that's what the "y" flag accomplished.

    If you want the number of months between the two dates, change that to "m".

    If this still isn't what you want, provide a more complete example problem.

    Date1 in cell A1
    Today's date is??
    Expected result would be: _________ (and why)

    • All times are GMT -7. The time now is 01:18 AM.