#1
|
|||
|
|||
help please
I have a date in column A and again in column E is there a code that I can use to get the days between in column F?
And if so, how do I go about doing this.....this is my first time using excel (im old) |
#2
|
|||
|
|||
Hi BBACCI,
I'm old too... You can simply subtract the earlier date from the later date and format it as a number or use the DateDif function. Read http://www.theexceladdict.com/_t/t040303.htm |
#3
|
|||
|
|||
just perform a sum. example in a1 you have 12-10-12 and in e1 you have 11-12-12 the sum a1 - b1 will show 28 days. Be sure to format the cell in column F as a general number or it will display as a date.
|
|