formula to calculate no of days from lastest dates

[breadwinner]

Dear experts

help me on this i have two dates i want calculate the no of days till today date from latest date of either A or B


if A 5/1/2013 B 7/1/2013 formula should calculate from B till today()
if A 7/1/2013 B 5/23/2013 formula should calculate from A till Today()

if A is blank B have Date 7/1/2013 Formula should calculate from B
if A have Date B is blank Formula should calculate from A

if both column are blank formula result "NO DATE"

please find the attachment i have enclosed example sheet

thanks to all

[Ace_XL]

In C2

=IF(COUNT(A2:B2),TODAY()-MAX(A2:B2),"No Date")

Copy down

[nested.if1@gmail.com]

Hi,

I think below formula will do.

Put this in C2 and drag to the end. Format cells as number.

=IF(AND(A2=0,B2=0),"NO DATE ",TODAY()-MAX(A2:B2)).

[Rambo4711]

Like this?

[Rambo4711]

Hi,

I think below formula will do.

Put this in C2 and drag to the end. Format cells as number.

=IF(AND(A2=0,B2=0),"NO DATE ",TODAY()-MAX(A2:B2)).

Apologize to nested.if1, as you already proposed the right solution

[breadwinner]

Dude if column extend to up to d in between b,c data and date is there then how max value work

[breadwinner]

Now i want calculate a and d cell values in between alphanumberic values there

check this attachment

[Rambo4711]

Why not insert the new columns before column A or after column C?

[nested.if1@gmail.com]

Hi,

May be something like this....

=IF(AND(A2=0,D2=0),"NO DATE ",TODAY()-IF(D2>A2,D2,A2))

[Rambo4711]

Why not insert the new columns before column A or after column C?

But if you want the new column inserted between column A and B here is the solution.