wilkisa
Well-known Member
- Joined
- Apr 7, 2002
- Messages
- 657
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
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.
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.