+ Reply to Thread
Results 1 to 3 of 3

Australian Financial Year from Month and year

  1. #1
    Registered User
    Join Date
    09-09-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2019
    Posts
    52

    Australian Financial Year from Month and year

    Hi,

    I've been wracking my brains to see whether it is possible to return the Australian Financial Year from the Year and and Month as per the attached Excel Doc.

    Currently I am entering in the Australian Financial Year manually, but there must be a formula that can achieve this?

    If anyone has any suggestions these would be appreciated.

    Thank you

    Tom
    Attached Files Attached Files
    Last edited by tomca; 09-10-2019 at 03:32 AM. Reason: solved

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Australian Financial Year from Month and year

    Try "A2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    copy paste down.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    09-09-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2019
    Posts
    52

    Re: Australian Financial Year from Month and year

    Quote Originally Posted by avk View Post
    Try "A2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    copy paste down.
    Great work avk. Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extracting Fiscal Year / Financial Year based on the Quarters using the
    By Asad Mir in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2019, 08:55 AM
  2. Replies: 3
    Last Post: 01-24-2019, 11:00 AM
  3. [SOLVED] How to get month and year of previous and current financial year?
    By mso3 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 04-11-2017, 05:19 AM
  4. Formula to Sum by Month and Financial Year
    By ColinAlice in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-28-2014, 07:34 AM
  5. [SOLVED] get the month, day and year of australian time
    By albert28 in forum Excel General
    Replies: 3
    Last Post: 04-19-2014, 05:05 AM
  6. [SOLVED] Australian Financial Year
    By mgs in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2013, 08:18 PM
  7. Replies: 3
    Last Post: 09-04-2013, 10:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1