using if condition with date function Closed

Question

Hello, 

Sir,

i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date column has date like 20/08/2015 and 2nd column has date like 21/08/2015. my status should be "Pickup done". but problem is that if I leave any column's cell blank it show wrong status. please help.


Configuration: Windows 7 / Chrome 44.0.2403.155

vcoolio · Answer

Hello Saifi,

If your dates are in Columns A & B then in Column C place the following formula:-

=IF(A1="","",IF(B1>A1,"Pickup Done","")) and drag it down as far as you need.

I hope that this helps.

Cheerio,
vcoolio.

Saifi · Answer

thank you so much, 
if I have to add some more status in this file like if we don't have date in these column then status should be anything. please help

vcoolio · Answer

Hello Saifi,

I'm not sure what you mean, but, in the above formula, if any cells are blank then nothing happens.

Have a look at my test work book here:-

https://www.dropbox.com/s/k5l9lmz97kx7322/Saifi.xlsx?dl=0

You can, of course, increase the "IF" statements and include other results (status).

Cheerio,
vcoolio.

Using if condition with date function

3 responses

Similar discussions

Subscribe To Our Newsletter!