Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
# Days Overdue
Hi,
I am trying to work out the simplest way to calculate the number of days overdue.
For example, due date was 07 Nov 2022, hence just looking for a simple equation to determine the number of days this has now been overdue.
I have tried to use = DATEDIF (<start date>, TODAY (), ādā) but seems to not work.
Any pointers will be greatly appreciated.
Many Thanks
RE: # Days Overdue
Hi Kay,
Thank you for the forum question.
Try
=today()-"Due Date"
Or if you want working days
=NETWORKDAYS("Due Date",TODAY())
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
