Using if condition with date function

[Closed]
Report
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
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.


3 replies

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.
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
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.