need formula for % in Excel

  katie613 14:21 15 Oct 2015

HI - I'm trying to get a % in excel on service levels met. Example: Date Expected to be complete - 10/12/2015 Date Completed - 10/13/2015 Can someone help me figure out a formula?

  Clapton is God 15:56 15 Oct 2015

I doubt it as there aren't 13 months in 2015.

  alanrwood 18:48 15 Oct 2015


The date is given in USA format ie month/date/year

  compumac 21:21 15 Oct 2015

How do you want the percentage expressed? It is a ratio of one to another. How does that reconcile against the two dates given?

  hastelloy 08:36 16 Oct 2015

The dates given are not enough. You need to know how long the job took and how long it was expected to take. You then take the former from the latter and tell excel to express it as %.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi 9 Release Date, Price & Spec Rumours

Illustrator Owen Davey on how he's created a successful series of animal-themed children's picture…

MacBook Pro 2019 release date, 16in MacBook Pro news and rumours

Xiaomi Mi 9 : date de sortie, prix et autres rumeurs