IsDate?
 

Hi! I have two columns, A and B. Each contains dates. In C I want to see the
number of days between the dates in A and B. This works fine using =days360
(I use swedish xl). But sometimes on of the date fields is empty. then it
gives a very big number. thus i want to check somehow if there really is a
date in col A and B. If there are dates then do the calc, if there are no
dates then dont write anything in c. how can i do this? thanks!

IsDate?
 

You can check for either of the cells being blank using this:

=IF(OR(A1="",B1=""),"",B1-A1)

and format the cell as nuber with 0 dp. This doesn't check explicitly
for dates, which are just numbers to Excel.

Hope this helps.

Pete

Arne Hegefors wrote:

Hi! I have two columns, A and B. Each contains dates. In C I want to see the
number of days between the dates in A and B. This works fine using =days360
(I use swedish xl). But sometimes on of the date fields is empty. then it
gives a very big number. thus i want to check somehow if there really is a
date in col A and B. If there are dates then do the calc, if there are no
dates then dont write anything in c. how can i do this? thanks!

IsDate?
 

Try this

=IF(AND(A1<"", B1<""), B1-A1, "")

Assumes dates are in A1 & B1 drag down if required

"Arne Hegefors" wrote:

Hi! I have two columns, A and B. Each contains dates. In C I want to see the
number of days between the dates in A and B. This works fine using =days360
(I use swedish xl). But sometimes on of the date fields is empty. then it
gives a very big number. thus i want to check somehow if there really is a
date in col A and B. If there are dates then do the calc, if there are no
dates then dont write anything in c. how can i do this? thanks!

IsDate?
 

=IF(COUNT(A1:B1)<2,"",B1-A1)


"Arne Hegefors" wrote:

Hi! I have two columns, A and B. Each contains dates. In C I want to see the
number of days between the dates in A and B. This works fine using =days360
(I use swedish xl). But sometimes on of the date fields is empty. then it
gives a very big number. thus i want to check somehow if there really is a
date in col A and B. If there are dates then do the calc, if there are no
dates then dont write anything in c. how can i do this? thanks!