Could someone look at the attached file and let me know why my datedif function is not working.
Thanks!!
Could someone look at the attached file and let me know why my datedif function is not working.
Thanks!!
You've reversed your start and end dates in the DATEDIF functions. The end date cannot be before the start date.
Switch them and the formulas will work as expected.
Does that help?
Also you probably need a couple more spaces;
=DATEDIF(B2,A2,"Y")&" Years, "&DATEDIF(B2,A2,"YM")&" Months, "&DATEDIF(B2,A2,"MD")&" Days"
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
Ahhhaaa!!!! I knew it had to be something simple! Thanks so much! And, yes, did a little formatting to make it easier to read.
Thanks again - you saved me from pulling all my hair out!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks