zubairahmed89
New Member
- Joined
- May 15, 2018
- Messages
- 2
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)
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)
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