exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi Team,
I have below data, i require a formula in column E where it should say pending / completed.
Wherever there is no todays date it should say pending and where todays date is present it should say completed.
Dates ate populated in this sheet by a vlookup from different sheet.
<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>
I have below data, i require a formula in column E where it should say pending / completed.
Wherever there is no todays date it should say pending and where todays date is present it should say completed.
Dates ate populated in this sheet by a vlookup from different sheet.
Column A | Column B | Column C | Column D | Column E | Column E |
Name | Date 1 | Date 2 | Date 3 | Date 3 | Expected Result |
Jack | 03/07/2019 | 02/07/2019 | 01/07/2019 | 27/06/2019 | Completed |
Rahul | 22/06/2019 | 02/07/2019 | 01/07/2019 | 27/06/2019 | Pending |
Silas | 02/07/2019 | Pending | |||
James | 02/07/2019 | Pending | |||
Jones | 02/07/2019 | 01/07/2019 | Pending | ||
Prem | 03/07/2019 | Completed | |||
Ram | 03/07/2019 | Completed | |||
Rajesh | 03/07/2019 | Completed | |||
Bruce | 03/07/2019 | Completed | |||
Vince | 03/07/2019 | 03/07/2019 | Completed | ||
Jacob | 03/07/2019 | 03/07/2019 | 03/07/2019 | 03/07/2019 | Completed |
Thomas | 03/07/2019 | 03/07/2019 | 03/07/2019 | Completed | |
Gill | 03/07/2019 | Completed | |||
Joy | Pending |
<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>