Using if condition with date function

Closed
Saifi - Aug 21, 2015 at 02:14 AM
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 - Aug 21, 2015 at 07:05 AM
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

vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 250
Aug 21, 2015 at 04:33 AM
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.
0
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
0
vcoolio Posts 1362 Registration date Thursday July 24, 2014 Status Moderator Last seen September 29, 2022 250
Aug 21, 2015 at 07:05 AM
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.
0