I have a spreadsheet that you enter out and in dates for equipment. I want to calculate the number of days, weeks and months. An example of what I'm looking for is if you enter dates and it is 64 days, this equals 2 months, 1 week, 1 day. I can get the number of month, but I'm not sure how to get weeks and days.
Any ideas??
Thanks
Any ideas??
Thanks