A afdmello Jul 8, 2009 #1 What formula will I use for calculating the number of days between : May 20,2005 and June 30,2009 Afd
What formula will I use for calculating the number of days between : May 20,2005 and June 30,2009 Afd
D Dave Peterson Jul 8, 2009 #2 Subtract the dates from one another and format the cell as General (make sure it's not a date): =a1-a2 (for example)
Subtract the dates from one another and format the cell as General (make sure it's not a date): =a1-a2 (for example)
S Shane Devenshire Jul 8, 2009 #3 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")
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")
A afdmello Jul 9, 2009 #4 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
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
G Gord Dibben Jul 9, 2009 #5 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
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
D Dave Peterson Jul 9, 2009 #6 or =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 Click to expand...
or =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 Click to expand...
