Can anyone tell me what formulae to use to calculate the difference between two dates in number of days, and then divide by 30 to give the number of "Periods", with value rounded to 2 decimal places in order to show the equivalent for the number of days shown as "Periods". A period will represent 30 days. Thank you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel date calculations
- Thread starter HelenL
- Start date
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,459
- Office Version
- 365
- Platform
- Windows
Are you looking for this (where A1 contains the earlier date and A2 the later date)?
=ROUND((A2-A1)/30,2)
Upvote
0
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,459
- Office Version
- 365
- Platform
- Windows
Sorry, but I have no experience with Pivot Tables, so I am unable to comment on your question.Rick thank you for the prompt replyI shall try that. Very much appreciated. Any thoughts please re my headache with the Pivot Table on a different thread?
Upvote
0
Similar threads
- Question
