A
afdmello
What formula will I use for calculating the number of days between :
May 20,2005 and June 30,2009
Afd
May 20,2005 and June 30,2009
Afd
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Subtract the dates from one another and format the cell as General (make sure
it's not a date):
=a1-a2
(for example)
it's not a date):
=a1-a2
(for example)
S
Shane Devenshire
Hi,
Careful with this idea, this is based on a 30 day month. I would go with
Dave's suggestion, or if you want a function
=DATEDIF(A1,A2,"d")
Careful with this idea, this is based on a 30 day month. I would go with
Dave's suggestion, or if you want a function
=DATEDIF(A1,A2,"d")
A
afdmello
Hi,
Thank you for your suggestions. However, May,20,2005 is the only date in the
cell.
D1 = May 20,2005
D2 = no of days elapsed from May 20,2005 until June 30,2009
How can I compute this?
Afd
Thank you for your suggestions. However, May,20,2005 is the only date in the
cell.
D1 = May 20,2005
D2 = no of days elapsed from May 20,2005 until June 30,2009
How can I compute this?
Afd
G
Gord Dibben
You need a start date and an end date
D1 May 20, 2005
D2 June 30, 2009
D3 =DATEDIF(D1,D2,"d") returns 1502
Gord Dibben MS Excel MVP
D1 May 20, 2005
D2 June 30, 2009
D3 =DATEDIF(D1,D2,"d") returns 1502
Gord Dibben MS Excel MVP
D
Dave Peterson
or
=date(2009,6,30)-d1
(formatted as General)
=date(2009,6,30)-d1
(formatted as General)
Hi,
Thank you for your suggestions. However, May,20,2005 is the only date in the
cell.
D1 = May 20,2005
D2 = no of days elapsed from May 20,2005 until June 30,2009
How can I compute this?
Afd