Forum Discussion
Formulas and Functions
Please Help - I'm no Excel expert!!
I am trying to improve a log of audit actions, more specifically their timescales for completion.
This is the formula I currently have in Cell M2:
=I...
Your criteria seems to have conflicting demands. All dates will eventually laspe when compared to the current date. You'll need to prioritze the criteria. Attahced is a file which I believe meets the criteria assuming "M" will always be green if "L" date is before "K" date regardless of today's date. If this does not meet your needs please indicate in the sheet which "M" states aren't correct.
- Hi Ismael,
Your formula seems to work the same as my current. Which is perfect apart from what I want to add, as follows:
If the date in Column L (Completion) Lapse over Column K (Timescale) It should go Red.It does. If L is past K it resutls in R.
