I want to calculate how many days there are between two different dates and have it as a whole numbere.g.in the cell I type(where A1 is 17/06/03 and A2 is 13/06/2003)=A1-A2I get a rather large number whereby I was expecting a value of 4 !!All help welcomeLouise
Have you formatted the cells as date?
Actually if you use =A1-A2 it should work as long as A1 and A2 are formatted as dates and the answer cell is formatted as number.If you are getting a number like 37789 (the date serial number for 17/06/03) then you are referencing the wrong cell(s) in your formula.
This thread is now locked and can not be replied to.
Samsung Galaxy S9 review
Wacom Cintiq Pro 24 and 32 review – hands-on
Best Mac video editors
Idées cadeaux pour geeks et tech addicts
© Copyright 2018 IDG UK. All Rights Reserved.