Thanks:  0
Likes:  0

1. 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.

2. Hiya,

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

3. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•