Days Between Dates

[grassyknoll63]

Hi,

I'm creating a tracking sheet and, have dates work is requested in I1 and dates work is completed in J1. And, in K1 I have the number of days it took. Until the work is completed, I'd like to have the days since work was requested in K1. Also, if both I1 and J1 are blank (no work requested, yet), I'd like the cell to be either blank or 0. Is this something someone may know how to solve?

Thanks!

gn

 

[Tetra201]

Try this:

=IF(I1="","",MIN(TODAY(),J1)-I1)

 

[grassyknoll63]

that doesn't work.

 

[FDibbins]

that doesn't work.

what doesn't work?
Wrong answer? No answer? Something else?
Are your dates real dates? test with =isnumber(cell-ref) FALSE indicates your dates are not real dates, and will need to be converted

 

[grassyknoll63]

This works! I have an ##### returned in one cell - not sure why but, the rest work great!
Thank you so much!

 

[FDibbins]

Probably a negative date?
Try making the column wider, see if that helps?

 

[grassyknoll63]

after widening the column, i get #VALUE!

But, no worries! I hide the rows after the job is done and, can enter this one manually.

Thanks so much! I really appreciate it!

 

[FDibbins]

If you click the cell, press F2 (edit) and then F9 (calc), what does it show? DONT press enter when done, press escape