Esther has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Date counting days
How can I easily count the days, if I have a start date mm/dd/yyyy and an end date mm/dd/yyyy. For example if I want to calculate the patient days on therapy of a medicine, to proof efficiency.
RE: date counting days
Hi Esther
Thanks for getting in touch. Counting with dates is quite straightforward; subtract one date from another. So if your end date is in cell A1 and start date is in cell B1, in C1 you can find out the difference with:
=A1-B1
If you need to find out only the week days, you can use:
=NETWORKDAYS(A1,B1)
I hope this helps.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best 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
