Using if condition with date function
Closed
Saifi
-
Aug 21, 2015 at 02:14 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Aug 21, 2015 at 07:05 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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.
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.
Related:
- Using if condition with date function
- Accessor function c++ - Guide
- Find function on mac - Guide
- Spreadsheet function - Guide
- Network card function - Guide
- Hard drive function - Guide
3 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Aug 21, 2015 at 04:33 AM
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.
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
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
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Aug 21, 2015 at 07:05 AM
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.
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.
