Using if condition with date function
Closed
Saifi
-
Aug 21, 2015 at 02:14 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Aug 21, 2015 at 07:05 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Aug 21, 2015 at 07:05 AM
Related:
- Using if condition with date function
- Network card function - Guide
- Function key stuck on - Guide
- Agp function - Guide
- Find function on mac - Guide
- Function of insert key - Guide
3 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
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.