months between dates

B

Bill H.

How to calc number of months between two user-specified dates?

(I supposed I'd want to round up to next whole number.)
 
A

ALESSANDRO Baraldi

Bill H. said:
How to calc number of months between two user-specified dates?

(I supposed I'd want to round up to next whole number.)
Click to expand...


Hi Bill you can try with DateDiff in this way:

DateDiff("m", Date1, Date2)

@Alex.(IT)
 
D

Duane Hookom

This depends on what you mean by "months between". How many months are
between 3/31/2004 and 4/1/2004 or 3/1/2004 and 3/31/2004?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inconsistent formatting of section numbers 0
Finding the proper style field and the numbered paragraph value within the style 0
Excel does not accept text format! 0
Calc Number of Months PER YEAR Between Dates 2
Finding the right style field in VBA 0
Autofill Date in Word 15.33 for Mac 0
number of months and days between two dates without approximation 3
Expanding Date Formula 0

Top