Page 1 of 3 123 LastLast
Results 1 to 12 of 29

Thread: Excel problem

  1. #1
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default Excel problem


    all member of IT DUNYA me ne excel me college ki ek work sheet bnani ha us me mujhe ye masla paish arha ha k me chata ho k jb me date of birth students ki likhon to wo mujh ko excat month days or Age btaye mjh ko formula ata ha lekin us se age or month ata ha days nhi
    me chata hon k 18-07-2009 tak student ki age 24 Years ho us se ziada over age pls help me

  2. #2
    ~*hiway*~'s Avatar
    ~*hiway*~ is offline Senior Member+
    Last Online
    22nd October 2011 @ 06:55 PM
    Join Date
    31 May 2007
    Location
    Khawabon Main .
    Posts
    15,131
    Threads
    364
    Credits
    0
    Thanked
    297

  3. #3
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    thnx jnab lekin ye formula me janta hon me chata hon k Days, month or Age btaye aisa formula ho mpls koi help karay

  4. #4
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Quote shahleopak said: View Post

    me chata hon k 18-07-2009 tak student ki age 24 Years ho us se ziada over age pls help me
    yaar aap key baat clear naheen ho rahi hay ???? aap sample sheet attach kar dain to mairi samjh main kuch aai ga .....
    MS Excel Main Result Tayar Karain! (If you completely finish this thread, your 60% concept of MS Excel will be cleared)
    http://itdunya.com/showthread.php?t=87020

  5. #5
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Farza Karain aap A1 cell main today date ya jub tuk aap ko umar chahiye likhtay hain
    A1=18-JUL-09 (Today's Date)
    A2=08-Dec-85 (Date of Birth)

    Aap yah formula A3 mian likhain to Year, Month and Date aaji gi ..

    A3=DATEDIF(A2,NOW(),"y") & " years, " & DATEDIF(A2,NOW(),"ym") & " months, " & DATEDIF(A2,NOW(),"md") & " days"

  6. #6
    saqib2pk's Avatar
    saqib2pk is offline Senior Member+
    Last Online
    17th December 2012 @ 02:35 PM
    Join Date
    14 Apr 2009
    Location
    KUWAIT
    Posts
    3,966
    Threads
    43
    Credits
    994
    Thanked
    5

    Default

    very nice bohut he acha ha
    CITY OF ANGELS AND ME

  7. #7
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    Mubashir Aziz bhai jan ap ye dekhen or mera masla hal kren
    Attached Images Attached Images  

  8. #8
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Suppose your data is in B column then write this formula in C2 and drag this formula downward

    =(TODAY()-B2)/365

  9. #9
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    Mubashir bhai m ne b aisay he likha ha lekin ap uper dekho age or month ata ha me chata hon days month or age aye
    corporate for thnx pls help me

  10. #10
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Yaar aap post # 5 wala formula use karo .... waisay yaar aap excel key file main likh kar bata dain to ziayda bahtar ho ga kah aap kia chahtay hain .. keonkah aap key batoon say pata he naheen lag raha hay kah aap actually chahtay kia hain ......

    Kia aap nay Post # 5 wala formula use kia hay ????????????????????

  11. #11
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    Mubashir bhai ap khud he check kr len wo formula to me janta hon mjh ko days month or age chaye
    Attached Images Attached Images  

  12. #12
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    aap ko days , month Ya Age chahiye ???? aap mujhay likh kar batain jaisay aap kay pass 39.6 aa raha hay iss main 39 years hain aur 6 month leekan ya formula bilkuk accurate naheen hota hay DATEDIF best formula hay ... leekan aap ujhay likh kar batain kah aap ko Total din aur total month chahiye kah kuch aur ??????

Page 1 of 3 123 LastLast

Similar Threads

  1. Excel problem
    By Qutab in forum Ask an Expert
    Replies: 4
    Last Post: 22nd November 2013, 03:48 PM
  2. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 17
    Last Post: 18th July 2012, 09:01 PM
  3. excel problem
    By Iqbalpk in forum Ask an Expert
    Replies: 2
    Last Post: 26th May 2012, 09:05 AM
  4. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 3
    Last Post: 22nd October 2011, 10:16 PM
  5. Excel Problem....
    By Adeawan in forum Ask an Expert
    Replies: 3
    Last Post: 6th March 2009, 06:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •