example, 27/05/06 to 26/06/07calcalute how many days
2006-07-26 01:28:39 · 3 answers · asked by josie 1 in Computers & Internet ➔ Other - Computers
if your first date i.e 27/05/06 is in A1 Column and second date i.e. 26/06/07 is in A2 Column then use this formula =A2-A1 and then select Comma Style from the formating toolbar.
2006-07-26 01:32:38 · answer #1 · answered by darshan 1 · 6⤊ 0⤋
Use this formula in whatever cell you want the calculation to show:
=days360(A1,A2)
with A1 being your start date and A2 being your end date. This will give you the # of days based on a 360 day year.
You could also enter:
=A2-A1
This gives you the true # of days based on a 365 day year
Make sure your date cells are formatted as dates, not text, and that your answer is formatted as general or a number.
2006-07-26 01:55:53 · answer #2 · answered by rosecitylady 5 · 0⤊ 0⤋
i believe excel has a fixed number associated with the date. then you can just do a subtraction.
2006-07-26 01:32:32 · answer #3 · answered by cw 3 · 0⤊ 0⤋