# Days Between Dates

#### grassyknoll63

##### New Member
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

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### Tetra201

##### MrExcel MVP
Try this:

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

#### grassyknoll63

##### New Member
that doesn't work.

#### FDibbins

##### Well-known Member
that doesn't work.

what doesn't work?
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

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

#### FDibbins

##### Well-known Member
Probably a negative date?
Try making the column wider, see if that helps?

#### grassyknoll63

##### New Member
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

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

Replies
3
Views
609
Replies
0
Views
575
Replies
3
Views
187
Replies
2
Views
289
Replies
1
Views
161

1,190,811
Messages
5,983,050
Members
439,817
Latest member
jessicabrown

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back