Notifications
Clear all
Topic starter
I want to create a date tracker in my excel workbook. This is a for an interactive work flow time line. How do I do this? Example, excel to tell me that an activity is overdue or so much time is left for an activity to be completed etc?
Thank You
Amit
Posted : 25/04/2019 11:55 pm
Firstly, you'll need to get an understanding of Excel's Date arithmetic - this is a good source:
http://www.cpearson.com/excel/datearith.htm
Basic tracking could involve IF statements where the logical test could depend on the difference between dates etc
Posted : 26/04/2019 12:07 am
This article by Mynda will also help
Posted : 26/04/2019 11:38 am
