+ Reply to Thread
Results 1 to 2 of 2

Display difference in 2 dates as xx.xx?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327

    Display difference in 2 dates as xx.xx?

    I'm using a formula to determine the difference between 2 dates - =DATEDIF(C3,E3,"y") & " years, " & DATEDIF(C3,E3,"ym") & " months"

    How can I have the result display "9.50" instead of 9 years 6 months

    I do need 2 decimals.

    Thanx

  2. #2
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Microsoft 365
    Posts
    327

    Re: Display difference in 2 dates as xx.xx?

    Aahhh - got it, =IF(E3="","",(DATEDIF(C3,E3,"m")/12))

    This works good.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1