201 Course Activity 17 Tenure

Options
elistewart
elistewart Member, ALL USERS Posts: 3 Occasional Contributor

Hi All,

 

I can't seem to get the correct tenure. The formula is working but the result is incorrect (see attached screenshots).

Could anyone think why this may be?

 

Thanks,

Elissa1.PNGformula.PNG

Tagged:

Comments

  • elistewart
    elistewart Member, ALL USERS Posts: 3 Occasional Contributor

    Hi Santhya,

     

    Thanks for your response.

    Yes I have used FY15 and the start date for Josh is 02/05/2015 (see attachments).

    Do you know what else could be the problem?

     

    Thanksrep set up.PNGtime.PNG,

    Elissa

  • elistewart
    elistewart Member, ALL USERS Posts: 3 Occasional Contributor

    Hi all,

    Please disregard, I had forgotten to format the dates to M-D-Y.

    Thanks