# Calulating the number of days between two dates

#### broncos347

##### Active Member
I am trying to calculate the no. of days between two dates (cols A and B). I have used the formula B-A to calculate the number of dates. However, I have some cells in the columns that do not have any dates yet.

Where I have a date in column A but not column B I would like to show a zero.

I also have some text in column A and a date I column B in this case I would also like to return a zero value.

Can anyone help?

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Something like

=IF(ISERROR(D8-C8),0,IF(D8="",0,D8-C8))

?

Excellent, thanks.

Replies
1
Views
115
Replies
3
Views
206
Replies
5
Views
338
Replies
1
Views
421
Replies
23
Views
351

Threads
1,196,073
Messages
6,013,269
Members
441,758
Latest member
Abren

### 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.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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