Please help calculate the number of days between dates

[wilkisa]

We have two cells with dates, formatted as mm/yyyy. We have created a VLookup to find the number of days in each month. However, they have now decided to sum the number of days between the start and end dates. What would be the best way to do it? They do not like the DAYS360 function.

Example:

Start Date: 03/2002
End Date: 07/2002

I need to know how to get it to calculate the number of days between 3/1 and 7/31, resulting in 153. These dates will change so the formula needs to be based on the two cell references.

Thanks for any help. I am leaving for the day but will check back in very early tomorrow morning.

[Asala42]

Hiya,

=(EndDate - StartDate) with the cell formated as a number should give you the raw number of days.

Adam

[Aladin Akyurek]

On 2002-04-15 13:40, wilkisa wrote:
We have two cells with dates, formatted as mm/yyyy. We have created a VLookup to find the number of days in each month. However, they have now decided to sum the number of days between the start and end dates. What would be the best way to do it? They do not like the DAYS360 function.

Example:

Start Date: 03/2002
End Date: 07/2002

I need to know how to get it to calculate the number of days between 3/1 and 7/31, resulting in 153. These dates will change so the formula needs to be based on the two cell references.

Thanks for any help. I am leaving for the day but will check back in very early tomorrow morning.

Simply:

=B2-A2

where B2 > A2, that is, B2 is the latest date.

Format the formula cell as General.