PDA

View Full Version : Dates



Phoenix1
05-12-2012, 11:47 PM
Can a program be written that will tell you how many years, months and days there are between two dates?

Bob Phillips
05-13-2012, 04:18 AM
Try

=DATEDIF(A2,B2,"Y")&" years "&DATEDIF(A2,B2,"YM")&" months "&DATEDIF(A2,B2,"MD")&" days"