Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1987
  • Last Modified:

Convert days to months

Hi Everyone

I have a formula that calculated the no of days between 2 dates.

What I want to do is convert the no of days into complete months

Thanks
Neil
0
nmilmine
Asked:
nmilmine
  • 4
  • 3
  • 2
  • +1
1 Solution
 
mgrattanCommented:
Use the DateDiff function:

datediff("m",<date1>,<date2>)
0
 
nico5038Commented:
Hi Neil,

Just checkout the date/time routines at: www.mvps.org/access

BTW complete months from days will differ depending on a startdate. e.g. before and after the 28th of februari...
so Datediff("m",..) could do the trick for you.

Nic;o)
0
 
senan072100Commented:
the result of substracting to date variables is number, so what about dividing it by 30 !!!
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
nico5038Commented:
Just typed too much too slow.... ;-(

Hi mgrattan ;-) !

Nic;o)
0
 
nmilmineAuthor Commented:
Thanks

Neil
0
 
mgrattanCommented:
You're welcome nmilmine.

Hi Nico!

Mike.
0
 
nico5038Commented:
(off record, sorry Neil)

Mike,

Missed your comments for a while !

Nic;o)
0
 
mgrattanCommented:
<Off topic again>

Hi Nico;

I've been poking my head into EE now and then but I'm so busy at work with Access, Excel VBA, and Essbase projects that I hardly have any time to visit.

Looks like you've been spending quite a bit of time here though!  If you like, email me at outuvtime at yahoo dot com.

Mike.
0
 
senan072100Commented:
Magrattan,, thanks,,, useful function.
0
 
mgrattanCommented:
You're quite welcome....

Mike.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now