nod

NOD (number of days) can be used to find the number of days in a given period.

 

Syntax   

NOD(BOP,EOP)

 

Use

This function has many uses but the most common use is to calculate daily average earnings.

 

E.g. to calculate the average per day from monthly production figures (node 120) you can use the following:

 

[120]/NOD(BOP,EOP)

 

In April NOD will give 30 days.

In May NOD will give 31 days.  

NOD with YTD in May will give 151 days.

 

This function will give February 29 days in leap years.

 

See NOP (Number of Periods) for more information.

 

How to create

In the Function calculator, select a node, click the NO button, and choose NOD. Make changes to the Start and End functions if necessary. Click OK when you are finished.

 

 

Version 5.1.2.0

This document contains confidential information. Not to be copied by third parties without written authorization.

© Copyright Corporater AS - All rights reserved.