Results 1 to 3 of 3

Thread: plz solve this-- Excel Help!!

  1. #1
    ihtesham_ulfat's Avatar
    ihtesham_ulfat is offline Senior Member+
    Last Online
    15th March 2014 @ 11:55 PM
    Join Date
    10 Jun 2007
    Location
    Multan
    Posts
    466
    Threads
    65
    Credits
    0
    Thanked
    3

    Exclamation plz solve this-- Excel Help!!

    Dear Members,

    men ny ecel ki aik file k aik cell men aik date likhi hia, maslan 05-jan-2010, us say agly colum men men ny days likhy dy maslan 10, dn, men chahta hoon k jesy hi men dys enter keron to agly colum men mujhy bata dy k itny dn baad kia date hogi.....!!??

    plz solve this...!
    Kindly Don't Share E-Mail Id In Your Signature.
    ITDunya.com Team

  2. #2
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default



    My assumption

    A1 hold date like 01-jan-2010
    B1 hold days to add like 10
    c1 enter this formula

    Code:
    =DATE(YEAR(A1),MONTH(A1),DAY(A1)+B1)
    Note :-date column must be formated to excel serial date

    regards

  3. #3
    ihtesham_ulfat's Avatar
    ihtesham_ulfat is offline Senior Member+
    Last Online
    15th March 2014 @ 11:55 PM
    Join Date
    10 Jun 2007
    Location
    Multan
    Posts
    466
    Threads
    65
    Credits
    0
    Thanked
    3

    Default

    Quote syar said: View Post


    My assumption

    A1 hold date like 01-jan-2010
    B1 hold days to add like 10
    c1 enter this formula

    Code:
    =DATE(YEAR(A1),MONTH(A1),DAY(A1)+B1)
    Note :-date column must be formated to excel serial date

    regards
    Thnk u brother, it done, Thanks for helping..!

Similar Threads

  1. MS Excel Experts plz solve my problem
    By Syed Hamid Ali in forum Ask an Expert
    Replies: 22
    Last Post: 30th December 2012, 05:13 PM
  2. Solved Excel main problem hy chote se, kn solve karay ga
    By King Mubashar in forum Solved Problems (IT)
    Replies: 7
    Last Post: 24th December 2011, 10:50 AM
  3. word and excel files corrupted plzz solve my problem
    By mawais152 in forum Ask an Expert
    Replies: 11
    Last Post: 30th July 2011, 12:38 PM
  4. Solved Slam Excel problems solve kr dain plz
    By DJ_UMAR in forum Solved Problems (IT)
    Replies: 4
    Last Post: 18th April 2011, 06:52 PM
  5. EXcel Formula Prob.. Solve Please
    By Refan in forum Ask an Expert
    Replies: 6
    Last Post: 25th May 2009, 03:19 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
  •