+ Reply to Thread
Results 1 to 3 of 3

Last date of Financial year

Hybrid View

vandanavai Last date of Financial year 08-30-2009, 04:12 AM
DonkeyOte Re: Last date of Financial... 08-30-2009, 04:18 AM
vandanavai Re: Last date of Financial... 08-30-2009, 08:53 AM
  1. #1
    Forum Contributor vandanavai's Avatar
    Join Date
    09-04-2006
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Last date of Financial year

    Hello

    I want to do following.
    Financial Year ended on 31st March.

    If date is 18th August 2008, Then last date for financial year is 31st March 2009.
    IF date is 15th March 2009, Then also last date for financial year is 31st March 2009.

    I want formula / function to get last date of financial yera.

    Please help.
    Last edited by vandanavai; 08-30-2009 at 08:54 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Last date of Financial year

    If by "date" you mean Today then:

    =DATE(YEAR(TODAY())+(MONTH(TODAY())>3),3,31)
    If by "date" you mean date in another cell, eg A1 then:

    =DATE(YEAR(A1)+(MONTH(A1)>3),3,31)

  3. #3
    Forum Contributor vandanavai's Avatar
    Join Date
    09-04-2006
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: Last date of Financial year

    Thanks a lot
    Thats what I was looking for.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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