Consulting

Results 1 to 2 of 2

Thread: Dates

  1. 05-12-2012, 11:47 PM #1
    Phoenix1
    Phoenix1 is offline
    VBAX Newbie
    Joined
    Apr 2012
    Posts
    2
    Location

    Cool Dates

    Can a program be written that will tell you how many years, months and days there are between two dates?
    Reply With Quote Reply With Quote
  2. 05-13-2012, 04:18 AM #2
    Bob Phillips
    Bob Phillips is offline
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try

    =DATEDIF(A2,B2,"Y")&" years "&DATEDIF(A2,B2,"YM")&" months "&DATEDIF(A2,B2,"MD")&" days"
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules