Results 1 to 11 of 11

Thread: Excel Mein Day and Years Colection.

  1. #1
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default Excel Mein Day and Years Colection.


    دوستو مجھے اپنی شیٹ میں ایسا فارمولہ لگانا ہے۔جس سے سال ،مہینے ،اور دن نکالنا ہیں۔
    جیسے سٹارٹ تاریخ 1جنوری 2005 ھے اور آخری تاریخ 15 دسمبر 2012 ہے
    تو شیٹ میں ایسا فارمولھ لگ سکے کہ پتہ چل جائے کے کھ اس میں کتنے سال کتنے مہینے اور کتنے دن ھو چکے ھیں۔

  2. #2
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default

    Quote Arshad2579 said: View Post

    دوستو مجھے اپنی شیٹ میں ایسا فارمولہ لگانا ہے۔جس سے سال ،مہینے ،اور دن نکالنا ہیں۔
    جیسے سٹارٹ تاریخ 1جنوری 2005 ھے اور آخری تاریخ 15 دسمبر 2012 ہے
    تو شیٹ میں ایسا فارمولھ لگ سکے کہ پتہ چل جائے کے کھ اس میں کتنے سال کتنے مہینے اور کتنے دن ھو چکے ھیں۔
    I assume start date A1 m aur End Date B1 m,

    =IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1," ym") &" months ")&DATEDIF(A1,B1,"md")&days"

    remember All date must be formated as Excel Serial Date.

    regards

  3. #3
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default

    بہت شکریہ
    Sir!
    لیکن یہ فارمولھ شیٹ پر آپلائی نہیں ھو رھا۔

  4. #4
    syar is offline Advance Member
    Last Online
    19th September 2024 @ 03:04 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    887
    Threads
    10
    Credits
    579
    Thanked
    340

    Default

    Quote Arshad2579 said: View Post
    بہت شکریہ
    Sir!
    لیکن یہ فارمولھ شیٹ پر آپلائی نہیں ھو رھا۔


    Sorry Last m double quote lagana bhool gaya tha. The correct formula in
    C1
    =IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1,"ym") &" months ")&DATEDIF(A1,B1,"md")&" days"

    regards

  5. #5
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default

    بہت شکریھ اب ٹھیک کام کر رھا ھے۔
    بہت شکریہ
    Problam Solved

  6. #6
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default

    Plz

  7. #7
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default


  8. #8
    moon_6432000's Avatar
    moon_6432000 is offline Senior Member+
    Last Online
    1st January 2024 @ 08:06 AM
    Join Date
    18 Jul 2008
    Location
    Kamra, Attock
    Age
    38
    Gender
    Male
    Posts
    530
    Threads
    13
    Credits
    129
    Thanked
    25

    Default


  9. #9
    Boor is offline Member
    Last Online
    19th March 2013 @ 05:16 PM
    Join Date
    17 Oct 2012
    Location
    Sukkur
    Gender
    Male
    Posts
    1,234
    Threads
    64
    Thanked
    54

    Default

    Quote syar said: View Post


    Sorry Last m double quote lagana bhool gaya tha. The correct formula in
    C1
    =IF(DATEDIF(A1,B1,"y")=0,"",DATEDIF(A1,B1,"y")&" years ")&IF(DATEDIF(A1,B1,"ym")=0,"",DATEDIF(A1,B1,"ym") &" months ")&DATEDIF(A1,B1,"md")&" days"

    regards
    Gud.
    Name:  Boo.png
Views: 114
Size:  85.5 KB

  10. #10
    Fahad87's Avatar
    Fahad87 is offline Advance Member
    Last Online
    11th May 2022 @ 04:58 PM
    Join Date
    29 Nov 2012
    Location
    Pakistan
    Gender
    Male
    Posts
    5,045
    Threads
    243
    Credits
    7,311
    Thanked
    265

    Default


  11. #11
    Arshad2579's Avatar
    Arshad2579 is offline Senior Member+
    Last Online
    22nd April 2020 @ 03:53 PM
    Join Date
    14 Jun 2012
    Location
    Shahkot,Panjab.
    Gender
    Male
    Posts
    502
    Threads
    33
    Credits
    71
    Thanked
    47

    Default


    DaN

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
  •