Due Date Summary based on multi-sheet spreadsheet

ArviLaanemets · #8 03-12-2020, 08:10 AM

OK. The formula for OnTime was faulty! Right one must be

Code:

=IF(AND([Delivered]=0,[DueDate]>TODAY()),"",AND([Delivered]>0,[Delivered]<=[DueDate]))

I.e. when:
1. Document is not delivered and due date is in future, then it is not late jet and OnTime field will be empty;
2. Document is not delivered and due date is today or earlier, then it is late or it is being late when not delivered immediately;
3. Document is delivered, and due date was later or equal than delivery date, then delivery was on time;
4. Document is delivered, but due date was earlier than delivery date, then delivery was late.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summriez all worksheet in summary work sheet	MILADREZAEE	Excel	7	05-21-2018 05:01 AM
How to calculate summary progress date time on summary tasks	Logotip	Project	0	05-16-2017 01:18 AM
Creating a dynamic summary sheet	FenelonPaul	Excel	5	09-23-2015 07:11 AM
Can a Data Source be one sheet in a multi-sheet Workbook	nfotx	Mail Merge	1	07-01-2015 12:55 AM
Construct a summary sheet by summing up from one or more than one sheet.	PRADEEPB270	Excel	1	11-04-2011 03:46 AM