days360 with today() shows different value

[anilpatni1234]

Hey Guys,

I need a small help.

Range "K" has the formulae

TODAY()

In range "L" I want to substract range "K" with range "D" using Days360

The formulae I am using in cell "L2" is

DAYS360(D2,K2)

The formulae works well but when range "d" is empty then it shows 42669

I want it to show blank if range "d" is empty


I have attached my workbook.

Please help me

[AliGW]

So this, then:

=IF(D2="","",DAYS360(D2,K2))

[anilpatni1234]

Hey ,

Thank you for your response.

I had worked out on this same formulae myself. But it does not work.
I am attaching the sample file. Please check.

It still shows 42669

[AliGW]

If you use Evaluate Formula on the Formulas ribbon you'll see why. Try this instead:

=IF(D2=0,"",DAYS360(D2,K2))

[anilpatni1234]

Hey Thank you .

Thanks so much.''

It worked