Hi All,
So I have a spreadsheet to record the time someone spends at our service. Column K shows the date that the person entered and column M the date that they left.
What I need in Cloumn L is a formula that calculates in Years, months and days the difference between the 2 if column M has a value and the difference between K and today's date if column M is blank
Hope that makes sense, I'm getting completely lost using IF functions??!?
Thanks in advance
Try this formula in L2
=DATEDIF(K2,IF(M2="",TODAY(),M2),"y")&" Years "&DATEDIF(K2,IF(M2="",TODAY(),M2),"ym")&" Months "&DATEDIF(K2,IF(M2="",TODAY(),M2),"md")&" Days"
Audere est facere
Danp123
Have you not already asked this question. You got a reply but did not bother to respond to it.
https://www.excelforum.com/excel-for...ml#post4633995
DominicB
It was a similar question but did not specify a breakdown of days, months etc. Apologies meant to respond then got snowed under in work
Perfect - Thanks Daddylonglegs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks