CCHGroup.com   Members   Support  
2 Replies Latest reply: Feb 5, 2013 12:01 PM by ben peters RSS

Date Function

Newbie
Currently Being Moderated

Is there or will there be a date function available for future years? Functions are available for prior period 1,2,3 etc. but for our note disclosures it would be nice to be able to do next period 1, 2, 3 etc.

 

  • Re: Date Function
    Ben Yust Newbie
    Currently Being Moderated

    Entering a negative number in the parentheses makes it a future year in my experience.  For instance, =pyedate(-1) will return the first future year and so on (in Excel).  In Word, you have to use the date function and then right-click to toggle field codes then add a "-" before the number in parentheses. 

  • Re: Date Function
    Newbie
    Currently Being Moderated

    You can also use the current year function.  For example =cy()+1

    This will return one year in the future.

More Like This

  • Retrieving data ...