+ Reply to Thread
Results 1 to 2 of 2

Calculating Finacial Periods from date

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    11-17-2006
    Posts
    152

    Calculating Finacial Periods from date

    hi,

    is there a way to calculate the finacial period from a date?
    i.e. 01/04/07 is period 1 in finacial terms
    so the date July-07 would return '4' as in period 4

    Thanks,

    Jon
    Last edited by jonn; 07-02-2007 at 11:52 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Maybe

    =MONTH(DATEVALUE("01/07/07"))-3
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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