zubairahmed89
New member
- Joined
- May 10, 2018
- Messages
- 7
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Hello Gurus
I need your help
I want to know How to link today's date against numerous dates mentioned in single column against the name of a person and completion status of that thing (like: Draft, In progress, Pending etc) I am attaching the excel sheet which i am working on View attachment 111.xlsx
In attachment on SHEET 1 Column G is where I want that formula. That formula will compare today's date against target dates, name of a person and Status from Sheet named (INVESTIGATIONS) from columns E and D respectively.
I hope I was able to define the problem well. Can anybody help, is it even possible?
Regards
Zubair
I need your help
I want to know How to link today's date against numerous dates mentioned in single column against the name of a person and completion status of that thing (like: Draft, In progress, Pending etc) I am attaching the excel sheet which i am working on View attachment 111.xlsx
In attachment on SHEET 1 Column G is where I want that formula. That formula will compare today's date against target dates, name of a person and Status from Sheet named (INVESTIGATIONS) from columns E and D respectively.
I hope I was able to define the problem well. Can anybody help, is it even possible?
Regards
Zubair