Date subtraction function in excel
Posted on 2012-09-22
I am trying to develop some metrics on task aging. I have a creation date for the task and a completion date. The problems I am having are:
Where the completion date cell is empty (not completed) I get a [#VALUE!] error
Where the completion date cell has a date earlier than the creation date I get a [#NUM!] error.
This is the formula I am using: (Q4 is the creation date and V4 is the completion date)
Which works fine when completion cell is populated and the date is more recent than the creation date (Ok, you will ask why I have a completion date earlier than a creation date, simply data entry errors which I'll fix when flagged hopefully by a minus days value)
One other factor that I am not sure if it is influencing this, is that the data is extracted from an oracle dB as an slk file???
Any help ;-)