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
Bookmarks