Hi all,

I'm trying to write a formula that will do the following:
  • Display the amount of days from a date to TODAY - (TODAY()-K2)
  • If another cell contains data, display the difference between the first and second date - (L2-K2)
  • Check to see if there is data in either data column, else leave blank - (=IF(K2="","",TODAY()-K2)

I've tried the following:
=IF(K2="","",TODAY()-K2,IF(L2="","",L2-K2))
...but it throws me a 'Too many arguments' error. I assume this is because I'm trying to check the cell for data first. Any ideas, or am I just asking too much on this one?

Thanks a ton!