0

Accounting Period Dates

Jet Reports Historic Posts

October 12, 2011 06:49

None

Follow

Is it possible to use a formula to get the starting and ending date of a period according to the Period number and Period Year we typed in another cell?

for example we fill in period "9" and Year "2011" .

regards,

robbert

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts October 12, 2011 07:02

  Is it possible to use a formula to get the starting and ending date of a period according to the Period number and Period Year we typed in another cell?
  
  for example we fill in period "9" and Year "2011" .
  
  regards,
  
  robbert

  
  ELMO: Sofar I use Vert.Lookup in Excel to a reference table with the period dates and numbers in Excel.
  Any better way would be welcome!
• 0
  
  Jet Reports Historic Posts September 17, 2014 12:08

  This should work where A1=YEAR (e.g. 2014) and A2=MONTH No. (e.g. 9).
  
  Start of month: =EOMONTH((($A$1-1900)*365.3+($A$2-1)*30.5),-1)+1
  End of month: =EOMONTH((($A$1-1900)*365.3+($A$2-1)*30.5),0)

• 0
  
  David Stockill July 31, 2019 07:25

  If you have non standard periods setup in Accounting Periods in NAV use the following to return start and end dates of current periods.

  Beginning of Period: =NL("last","Accounting Period","Starting Date","Starting Date",".."&TODAY(),"Closed","False")

  End of Period: =NL("first","Accounting Period","Starting Date","Starting Date",TODAY()&"..","Closed","False")-1