Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

HOW TO USE FORMULA

Discussion in 'Information Technology' started by SELUKU, Jul 28, 2006.

Tags:
  1. SELUKU

    SELUKU
    Expand Collapse
    Guest

    IF I WANT TO ENTER THE DATE OF BIRTH AND WANT TO THE AGES WICH FORMULA MUST I
    USE
     
  2. Loading...


  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

  4. Rick B

    Rick B
    Expand Collapse
    Guest

    How to calculate Age
    DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")>Format(Date(),"mmdd"))


    --
    Rick B



    "SELUKU" <SELUKU@discussions.microsoft.com> wrote in message news:693606BD-C90C-41B4-8FE8-6A218F4FC3DD@microsoft.com...
    > IF I WANT TO ENTER THE DATE OF BIRTH AND WANT TO THE AGES WICH FORMULA MUST I
    > USE
     

Share This Page