excel - Process tracker - formulas, vba or conditional formatting? -


i started make excel ”tracker”, can follow how goes process. have 6 steps in need track: step 1, step 2, step 3, step 4, step 5 , step 6. have start , deadline date. step 1-3 estimated finished 20 days before deadline. step 4 need finished 6 days before deadline, step 5 5 days before deadline.

i need tracker show ”semi-behind” if these not achieved. if process going after plan column n have show “on track”. if deadline date passed, column have “behind”. if difference between start date , deadline date less 20 days, column n have “asap”.

do have idea how can make this? formulas, vba or conditional formatting?

i think can use formula. let's says put start date in column l2, processdate in column m2 deadline in column n2 , formula in column o2 this:

=if(and((n2-m2)<20,(n2-m2)>0),"asap",if(m2>l2,"on track",if(m2>n2,"behind","semi-behind"))) 

hope help.


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -