
Amit Shrestha
New Member
Members

Forum Posts: 1
Member Since:
April 25, 2019
April 25, 2019

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

Kevin Junk
Member
Members

Forum Posts: 23
Member Since:
October 18, 2018
October 18, 2018

Firstly, you'll need to get an understanding of Excel's Date arithmetic - this is a good source:
http://www.cpearson.com/excel/.....earith.htm
Basic tracking could involve IF statements where the logical test could depend on the difference between dates etc
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Terry Hedditch, Jack Aston, Shoua Lee, Hilary Burchfield
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Forum Stats:
Groups: 3
Forums: 24
Topics: 6545
Posts: 28653
Member Stats:
Guest Posters: 49
Members: 32831
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
