Results 1 to 7 of 7

Thread: EXCEL EXPERTS PLZZ HELP

  1. #1
    amirshahzadd is offline Senior Member+
    Last Online
    1st June 2019 @ 12:12 PM
    Join Date
    07 May 2010
    Posts
    296
    Threads
    14
    Credits
    283
    Thanked
    22

    Default EXCEL EXPERTS PLZZ HELP

    میں نے ایک ایکسل فائل اٹیچ کی ہے مجھے اس فرسٹ کالم کی ڈیٹ سے سیکنڈ کالم کی ڈیٹ کے بییچ کا پیریڈ چاہیے
    تو بتائیے کیا فارمولا اپلائی ہو گا
    Attached Files Attached Files

  2. #2
    Join Date
    06 Jan 2014
    Location
    Saudi , Makkah
    Age
    30
    Gender
    Male
    Posts
    3,178
    Threads
    304
    Credits
    2,092
    Thanked
    443

    Default

    question hi samajh nahi aya,,
    ap kua poochna chah rahe ho??

  3. #3
    amirshahzadd is offline Senior Member+
    Last Online
    1st June 2019 @ 12:12 PM
    Join Date
    07 May 2010
    Posts
    296
    Threads
    14
    Credits
    283
    Thanked
    22

    Default

    Quote ahadi958 said: View Post
    question hi samajh nahi aya,,
    ap kua poochna chah rahe ho??
    بھائی سمجھ میں نہ آنے کی کیا بات ہے سمپل تو بتایا ہے
    خیر ایکسپلین کرتا ہوں
    میں نے جو دو تاریخ دیں ہیں ان دونوں کے درمیان کتنا وقفہ ہے
    مطلب کتنے سال مہینہ دن
    سال مہینہ کا بھی پتہ چلے تو کافی ہے

  4. #4
    Geeky's Avatar
    Geeky is offline Senior Member+
    Last Online
    12th July 2016 @ 10:31 AM
    Join Date
    12 Mar 2016
    Location
    Earth
    Age
    28
    Gender
    Male
    Posts
    271
    Threads
    4
    Credits
    1,606
    Thanked
    13

    Default

    Quote amirshahzadd said: View Post
    میں نے ایک ایکسل فائل اٹیچ کی ہے مجھے اس فرسٹ کالم کی ڈیٹ سے سیکنڈ کالم کی ڈیٹ کے بییچ کا پیریڈ چاہیے
    تو بتائیے کیا فارمولا اپلائی ہو گا
    Use this Function > =DATEDIF("01/01/2001","01/01/2007","y")
    Here,
    01/01/2007 is Starts date.
    01/01/2007 is Ends date.
    And "y" is initials.. Agr ap year difference maloom krna chahy tou "y", Month ho tou "m" ya Date ho tou "d" ka initial use karain...

  5. #5
    amirshahzadd is offline Senior Member+
    Last Online
    1st June 2019 @ 12:12 PM
    Join Date
    07 May 2010
    Posts
    296
    Threads
    14
    Credits
    283
    Thanked
    22

    Default

    Quote Geeky said: View Post
    Use this Function > =DATEDIF("01/01/2001","01/01/2007","y")
    Here,
    01/01/2007 is Starts date.
    01/01/2007 is Ends date.
    And "y" is initials.. Agr ap year difference maloom krna chahy tou "y", Month ho tou "m" ya Date ho tou "d" ka initial use karain...
    bhai hal tu mainay net say search karkay nikal hi lia tha laiken jo file attach ki hai u s per karkay dikhayen mujhe

  6. #6
    Geeky's Avatar
    Geeky is offline Senior Member+
    Last Online
    12th July 2016 @ 10:31 AM
    Join Date
    12 Mar 2016
    Location
    Earth
    Age
    28
    Gender
    Male
    Posts
    271
    Threads
    4
    Credits
    1,606
    Thanked
    13

    Default

    Quote amirshahzadd said: View Post
    bhai hal tu mainay net say search karkay nikal hi lia tha laiken jo file attach ki hai u s per karkay dikhayen mujhe
    Aap apni Attach ki hui File dubara dekhain uski Sequence kesi hai, Date separation mein kahin "-" use hua hai kahin "/" or kahin 01/01/2007 is format main date hai tou kahin 01-jan-2007/1-3-15 or etc.. Tou pehly uski sequence behtar hai k 01/01/2007 is format mein karain then apply =datedif Formula..

  7. #7
    amirshahzadd is offline Senior Member+
    Last Online
    1st June 2019 @ 12:12 PM
    Join Date
    07 May 2010
    Posts
    296
    Threads
    14
    Credits
    283
    Thanked
    22

    Default

    Quote Geeky said: View Post
    Aap apni Attach ki hui File dubara dekhain uski Sequence kesi hai, Date separation mein kahin "-" use hua hai kahin "/" or kahin 01/01/2007 is format main date hai tou kahin 01-jan-2007/1-3-15 or etc.. Tou pehly uski sequence behtar hai k 01/01/2007 is format mein karain then apply =datedif Formula..
    Thanks Dear wo file to kisi nay mujhe aisay hi send ki thi aur mainay idher upload kar di
    mainay bhi bad main 3 rows ki date theik kar kay forumla apply kia
    main cheez forumla thi baki ka kam wo karta rahta
    mainay sirf usay formula dhoondh kay dia hai

Similar Threads

  1. Urgent help plzz.excel file delete restore ksy ho gi
    By malikasad128 in forum Ask an Expert
    Replies: 2
    Last Post: 16th June 2015, 08:05 AM
  2. plzz help experts plzz
    By Arslanahmad3 in forum Mobile phones problems and Help Zone
    Replies: 1
    Last Post: 3rd July 2013, 06:33 AM
  3. Excel problem Plzz slove kardo.
    By Boor in forum Ask an Expert
    Replies: 8
    Last Post: 31st December 2012, 04:48 PM
  4. Solved excel help plzz
    By GreatKhan1 in forum Solved Problems (IT)
    Replies: 6
    Last Post: 31st August 2012, 10:38 PM
  5. printers experts plz plzz plzz help
    By preety_sweet in forum Ask an Expert
    Replies: 5
    Last Post: 25th August 2009, 01:24 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
  •