difference between two dates

**allems** · 11-15-2011, 03:38 AM

Hi... new here and need some help with my worksheet
on column C, i need the difference (from date of admission and discharge) / i used the formula =datedif(d-c) and =d-c / all didnt work; also it would be best if the result highlights less than 2 days. On the column e, i would need the difference between discharge date and dictate date / much similar to the previous columns, and highlight the result of more than 30 days; so it will be easier to recognize the files that are incomplete.

appreciate if anyone can help me out

thank you

**tom1977** · 11-15-2011, 03:43 AM

First of all You have to change the data format because You use text instead of data

p.s. I've changed Your data now You can do calculations

**allems** · 11-15-2011, 04:25 AM

Thanks tom1977
yes, exactly what i need, but how come i applied it in my original worksheet, it doesnt work and gives me #VALUE!..
does it have to with the data and text that you mentioned? how can i change it myself?
really appreciate your help.

**arthurbr** · 11-15-2011, 04:30 AM

Col A and B are not dates but text looking like dates

To adapt, select the data in Col A
Go to Data - Text to columns
Next - Next
In the last window select DMY as Date format and Finish

Same procedure for col B

Col D is OK

To check if it is text or note you can enter =ISTEXT(cell_with_date) in an empty cell
If it returns TRUE, you know what to do

Or, right click the dubious cell - Go to format cells - Click he Nimber tab - Click general.
If it reads something like 40987 you're OK. If the date remains, you'll have to adapt

EDIT also have a look at http://www.cpearson.com/excel/datetime.htm#AddingDates

**tom1977** · 11-15-2011, 04:36 AM

You have to use "text to columns" command on the ribbon to change the format. Unfortunately I have polish version of excel so it could be difficult to explain.