Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel function usage

Options
  • 19-06-2003 1:28pm
    #1
    hamster
    Registered Users 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

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


    Try this site...

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


  • Options
    #3
    hamster
    Registered Users 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! :)


  • Options
    #4
    Typedef
    Closed Accounts Posts: 5,564 ✭✭✭Typedef


    You could always just edit the SQL.

    *You looking for a relational database query baby?


  • Options
    #5
    hamster
    Registered Users 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) ?


  • Options
    #6
    Typedef
    Closed Accounts Posts: 5,564 ✭✭✭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
  • Options
    #7
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 91,761 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....


  • Options
    #8
    Typedef
    Closed Accounts Posts: 5,564 ✭✭✭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