Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel function usage

  • 19-06-2003 12:28PM
    #1
    hamster
    Registered Users, Registered Users 2 Posts: 1,766 ✭✭✭


    Does anyone know how to do the following in Excel to return the number of months from a given date:

    I know TODAY() returns today's date. eg. 19/06/2003

    I want to get the number of months passed since (rounded up), eg. TODAY() - 19/04/2003 = 2

    Is this possible? I don't mind if I have to do further conversions if it defaults to secs or days etc.

    Thanks. ww)


Comments

  • #2
    Polonious
    Registered Users, Registered Users 2 Posts: 245 ✭✭Polonious


    Try this site...

    http://www.cpearson.com/excel/datearith.htm


  • #3
    hamster
    Registered Users, Registered Users 2 Posts: 1,766 ✭✭✭hamster


    Thanks for link....

    I got another suggestion which fits the bill:

    =ROUNDUP((YEARFRAC("08/07/1999",TODAY(),3)*12),0)

    assuming tools-> addins-> analysis toolpak is checked.


    Must have a look at the the link thanks again! :)


  • #4
    Typedef
    Closed Accounts Posts: 5,563 ✭✭✭Typedef


    You could always just edit the SQL.

    *You looking for a relational database query baby?


  • #5
    hamster
    Registered Users, Registered Users 2 Posts: 1,766 ✭✭✭hamster


    Originally posted by Typedef
    You could always just edit the SQL.

    *You looking for a relational database query baby?

    Typedef,

    I have this in an excel sheet in one cell. What sql query are you refering to (or is the sql generated in the background) ?


  • #6
    Typedef
    Closed Accounts Posts: 5,563 ✭✭✭Typedef


    Nah, I'm thinking of SQL view in access.

    This allows you to basically munge about your own SQL.

    Very handy... for an M$ product that is.

    But you know, excel probably allows you to inline sql as functions etc.

    I'd check it out.


  • Advertisement
  • #7
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 97,532 Mod ✭✭✭✭Capt'n Midnight


    that SQL was not designed by M$

    so Typedef I doubt you'll find it - hey suprise me


    TBH - M$SQL has one redeeming feature - for which most things are forgiven - You can backup by dumping to a file while online - and more important the restore is fairly quick and painless. (compared to all the other backoffice apps this is just soooooo nice)

    Pity they changed the licencing so you can't use Citrix or TS to save licences for ocassional users....


  • #8
    Typedef
    Closed Accounts Posts: 5,563 ✭✭✭Typedef


    Originally posted by Capt'n Midnight

    TBH - M$SQL has one redeeming feature - for which most things are forgiven - You can backup by dumping to a file while online

    Considering M$SQL was Sybase code up until interation 6.5...

    Besides PostgreSQL allows the same thing.
    It just locks the tables (rightly) while it's doing the dump.


Advertisement
Advertisement