Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - # of Months between 2 dates 1

Status
Not open for further replies.
jbh1378

jbh1378

Technical User
Dec 11, 2001
15
US
I have a start date and an end date in two different cells in excel. I want to get the true # of months (not assuming 30 day months) between those dates.
 
Sort by date Sort by votes
Is DATEDIF what you need?

The results of the calculation are displayed as days, full months, and full years.
You must enter the formula manually--the formula is not located in Paste Function.

datedif.gif
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Use 2 columns in Detail Section of report 1
Replies
8
Views
840
TrekBiker
TrekBiker
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
570
mintjulep
M
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
961
bs6600
bs6600
ladyck3
  • Locked
  • Question
Excel 365 (2016) Working to auto-populate dates 3
Replies
13
Views
761
ladyck3
ladyck3
Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
431
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top