Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the number of days from a specific date
I would like a formula which would enable me to calculate the number of days
from a specific date. It's difficult to explain but hopefully the following example illustrates what I need: Example 1: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 12/3/2006 Column D: Result: 63 Example 2: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 9/18/04 Column D: Result: 352 The calculation is performed on the start date and the hire date giving the result in Column D. I am not concerned with the year. Both dates can be different years. I just need to know how many days there are from the start date, in this case October 1, to the hire date. I hope I have explained this clearly. Any help would be greatly appreciated. Thanks Eugene |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the number of days from a specific date
12/3/2006 - 10/1/2005 = 428 Not 63 but Put this into cell D1
=C1-A1 "Oceangate" wrote: I would like a formula which would enable me to calculate the number of days from a specific date. It's difficult to explain but hopefully the following example illustrates what I need: Example 1: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 12/3/2006 Column D: Result: 63 Example 2: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 9/18/04 Column D: Result: 352 The calculation is performed on the start date and the hire date giving the result in Column D. I am not concerned with the year. Both dates can be different years. I just need to know how many days there are from the start date, in this case October 1, to the hire date. I hope I have explained this clearly. Any help would be greatly appreciated. Thanks Eugene |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the number of days from a specific date
Mike,
Thanks for your reply. But as I said, I'm not concerned with the year, just the months but I have to deal with them somehow in a formula. So, in the case you noted, from 10/1 to 12/3 is 63 days disregarding the year. That's my problem. I need a formula that will calculate the above regardless of the years in both dates. Thanks Eugene "Mike" wrote: 12/3/2006 - 10/1/2005 = 428 Not 63 but Put this into cell D1 =C1-A1 "Oceangate" wrote: I would like a formula which would enable me to calculate the number of days from a specific date. It's difficult to explain but hopefully the following example illustrates what I need: Example 1: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 12/3/2006 Column D: Result: 63 Example 2: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 9/18/04 Column D: Result: 352 The calculation is performed on the start date and the hire date giving the result in Column D. I am not concerned with the year. Both dates can be different years. I just need to know how many days there are from the start date, in this case October 1, to the hire date. I hope I have explained this clearly. Any help would be greatly appreciated. Thanks Eugene |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the number of days from a specific date
If your start dt is in A1 and hire dt in b1 then enter this in C1 and copy down
=IF(B2<A2,MOD(365+B2-A2,365),MOD(B2-A2,365)) The result may be off by the number of leap years in the date range... "Oceangate" wrote: I would like a formula which would enable me to calculate the number of days from a specific date. It's difficult to explain but hopefully the following example illustrates what I need: Example 1: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 12/3/2006 Column D: Result: 63 Example 2: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 9/18/04 Column D: Result: 352 The calculation is performed on the start date and the hire date giving the result in Column D. I am not concerned with the year. Both dates can be different years. I just need to know how many days there are from the start date, in this case October 1, to the hire date. I hope I have explained this clearly. Any help would be greatly appreciated. Thanks Eugene |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the number of days from a specific date
=MOD(C1-A1,365)
"Oceangate" wrote: I would like a formula which would enable me to calculate the number of days from a specific date. It's difficult to explain but hopefully the following example illustrates what I need: Example 1: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 12/3/2006 Column D: Result: 63 Example 2: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 9/18/04 Column D: Result: 352 The calculation is performed on the start date and the hire date giving the result in Column D. I am not concerned with the year. Both dates can be different years. I just need to know how many days there are from the start date, in this case October 1, to the hire date. I hope I have explained this clearly. Any help would be greatly appreciated. Thanks Eugene |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate the number of days from a specific date
That worked perfectly.
Thanks!! "Sheeloo" wrote: If your start dt is in A1 and hire dt in b1 then enter this in C1 and copy down =IF(B2<A2,MOD(365+B2-A2,365),MOD(B2-A2,365)) The result may be off by the number of leap years in the date range... "Oceangate" wrote: I would like a formula which would enable me to calculate the number of days from a specific date. It's difficult to explain but hopefully the following example illustrates what I need: Example 1: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 12/3/2006 Column D: Result: 63 Example 2: Column A: Start Date: 10/1/2005 Column B: End Date: 9/30/2006 Column C: Hire Date: 9/18/04 Column D: Result: 352 The calculation is performed on the start date and the hire date giving the result in Column D. I am not concerned with the year. Both dates can be different years. I just need to know how many days there are from the start date, in this case October 1, to the hire date. I hope I have explained this clearly. Any help would be greatly appreciated. Thanks Eugene |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
business day date from a specific date based on a number of days | Excel Worksheet Functions | |||
calculate a date X number of days before/after given date | Excel Worksheet Functions | |||
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY | Excel Worksheet Functions | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
calculate the number of days from date received | Excel Worksheet Functions |