Date function that compare 2 date in single column and return value

[alimamak]

Hi

How to write simple date function that will compare 2 date in single column and then will return statement "write off" or "still use" if it meet the condition

example

Column A Column B
12/07/2005 Write Off
12/07/2012 still use



from example if in date column a is more than the today date, it will automatic show in column B write off else if less than today it will show still in use. This date comparison is to check if the date at column A is more than 2 years or less. This is for inventory system that see if the item is more than or reach 2 years, it will show write off or if less than 2 years, it will show still use


thanks
abu

[dilipandey]

HI Abu,

Use below formula in Column B and drag down :-

=IF(TODAY()-A1>=730,"Write Off", "Still Use")

Regards,
DILIPandey

<click on below 'star' if this helps>

[alimamak]

thanks dili, that script can be use plus or minus?
i never though it can be like that

it now works

thanks again

abu

[dilipandey]

You are welcome Abu

For plus or minus, you can interchange the position of Today and A1 ... cheers


Regards,
DILIPandey

<click on below 'star' if this helps>

[alimamak]

what value 730 use for? 2 years in days?

[dilipandey]

Yes.. it is 365 x 2= 730.

You can further customize this number as per your criteria

Regards,
DILIPandey


<click on below 'star' if this helps>

[alimamak]

ok dili, thanks again

abu

[dilipandey]

you are welcome abu... cheers

Regards,
DILIPandey

<click on below 'star' if this helps>