Page 1 of 2 12 LastLast
Results 1 to 12 of 16

Thread: Ms-Office (Excel Sheet) Help Required

  1. #1
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    37
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default Ms-Office (Excel Sheet) Help Required



    kya excel sheet main koi aisa formula hi.. k aj maine 30 lekha to kal woh automatically 29 ho jaye?

  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

    Salam:

    Can u explain a bit.

  3. #3
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    37
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    bahi seedhi c bat ki hi.. k agar main excel main 30 lekhta hon.. to kya yeh possible hi k woh automatically kal 29 ho jaye? matlab muje zarorat na parha osko 29 karna ki

  4. #4
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    37
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    koi hi jo jawab dy saqy?

  5. #5
    GMD's Avatar
    GMD is offline Senior Member+
    Last Online
    13th September 2015 @ 02:33 PM
    Join Date
    05 Feb 2009
    Location
    Rahim Yar Khan
    Age
    44
    Gender
    Male
    Posts
    445
    Threads
    45
    Credits
    990
    Thanked
    14

    Default

    baat kuch samajh nahi ayi brother

  6. #6
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    37
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    yar saf saf to keh raha hon k agar aj 4 march ko main excel main ik column main , main 30 lekhta hon, r 5 march ko automatically woh 29 ho jaye,
    r 6 march ko woh automatically 28 ho jaye..
    is tarha ka koi function mil jaye ya
    muje aisa mmil jaye k agar aj 4 march ko main '1' lekhta hon, to woh 5 march ko '2' automatically ho jaye ok?

    Quote GMD said: View Post
    baat kuch samajh nahi ayi brother

  7. #7
    bais is offline Senior Member
    Last Online
    31st July 2015 @ 02:07 PM
    Join Date
    23 Aug 2008
    Location
    Izlooo
    Gender
    Male
    Posts
    3,519
    Threads
    96
    Thanked
    263

    Default

    Quote fwdwaseem said: View Post


    kya excel sheet main koi aisa formula hi.. k aj maine 30 lekha to kal woh automatically 29 ho jaye?
    =======================
    solutions

    If u more clear your point what u wants then may it possible for its solutions at the earliest

  8. #8
    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

    you can achieve by two methods
    1. by Event Macro
    2. By Formula.

    BUt the easiest way to achieve this by formula. I assume aap excel 2007/2010.Follow this procedure.

    1.Formula ka tabe m Define Name par click karain.
    2. Name k box m apne marze ka name lekhain for example "c_date"
    3. aur refer to k box m apni date lekhain jese ap na kaha 4th march. Date must be in dd/mm/yyyy format. e.g =3/4/2012
    4. Ok click Karain.

    Then again formula k tab m define name m ja kar Define name par click karain.
    1. Refer k name m apni marze ka name d e.g. elapseday
    2. refer to k box m
    Code:
    =today()-c_day
    enter kar ka enter kar dain.


    Ab aap jahan par apna number lekhtain hain for example a1 m agar ap 30 lekhtain tu is k jagha ye formula lekhain.

    a1 m enter karain.
    =30-elapseday
    aur enter karain.

    Note: Name aap apne marze k define kar sakte hain.

    is ka dosra method event procedure hain. Agar ap ko macro programing ki know how ha tu you can do otherwise it will difficult.

    regards.

  9. #9
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    37
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    ms-office 2003 main yeh formula tab kaha hoga??
    main ms-office 2003 use kar raha hon

    Quote syar said: View Post
    you can achieve by two methods
    1. by Event Macro
    2. By Formula.

    BUt the easiest way to achieve this by formula. I assume aap excel 2007/2010.Follow this procedure.

    1.Formula ka tabe m Define Name par click karain.
    2. Name k box m apne marze ka name lekhain for example "c_date"
    3. aur refer to k box m apni date lekhain jese ap na kaha 4th march. Date must be in dd/mm/yyyy format. e.g =3/4/2012
    4. Ok click Karain.

    Then again formula k tab m define name m ja kar Define name par click karain.
    1. Refer k name m apni marze ka name d e.g. elapseday
    2. refer to k box m
    Code:
    =today()-c_day
    enter kar ka enter kar dain.


    Ab aap jahan par apna number lekhtain hain for example a1 m agar ap 30 lekhtain tu is k jagha ye formula lekhain.

    a1 m enter karain.
    =30-elapseday
    aur enter karain.

    Note: Name aap apne marze k define kar sakte hain.

    is ka dosra method event procedure hain. Agar ap ko macro programing ki know how ha tu you can do otherwise it will difficult.

    regards.

  10. #10
    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

    Office 2003 m Insert k Menu m Name Manager k function hot e hain.

    regards,

  11. #11
    fwdwaseem's Avatar
    fwdwaseem is offline Senior Member+
    Last Online
    29th January 2021 @ 05:57 PM
    Join Date
    21 Dec 2010
    Location
    Rawalpindi
    Age
    37
    Gender
    Male
    Posts
    188
    Threads
    49
    Credits
    1,208
    Thanked
    7

    Default

    brother ap na jo tareeka batya hi... os procedure k through ho nhe raha...
    error hi..
    formula not recognized?

    #NAME? wala error


    Quote syar said: View Post
    you can achieve by two methods
    1. by Event Macro
    2. By Formula.

    BUt the easiest way to achieve this by formula. I assume aap excel 2007/2010.Follow this procedure.

    1.Formula ka tabe m Define Name par click karain.
    2. Name k box m apne marze ka name lekhain for example "c_date"
    3. aur refer to k box m apni date lekhain jese ap na kaha 4th march. Date must be in dd/mm/yyyy format. e.g =3/4/2012
    4. Ok click Karain.

    Then again formula k tab m define name m ja kar Define name par click karain.
    1. Refer k name m apni marze ka name d e.g. elapseday
    2. refer to k box m
    Code:
    =today()-c_day
    enter kar ka enter kar dain.


    Ab aap jahan par apna number lekhtain hain for example a1 m agar ap 30 lekhtain tu is k jagha ye formula lekhain.

    a1 m enter karain.
    =30-elapseday
    aur enter karain.

    Note: Name aap apne marze k define kar sakte hain.

    is ka dosra method event procedure hain. Agar ap ko macro programing ki know how ha tu you can do otherwise it will difficult.

    regards.

  12. #12
    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

    Brother ap ne jo error bataya ha ye is waqt ata ha jab ap name manager m name wrong define karte hain. Agar ho sake tu ap apne file attached kar dain. aur attached file ko bhe check kar lain.

    regards,
    Attached Files Attached Files

Page 1 of 2 12 LastLast

Similar Threads

  1. Microsoft Office 2010
    By Max_ in forum English IT Zone
    Replies: 32
    Last Post: 30th September 2015, 12:44 PM
  2. remove office non genuine error
    By mirza matloob in forum General Discussion
    Replies: 2
    Last Post: 6th August 2011, 03:41 PM
  3. Replies: 1
    Last Post: 27th January 2010, 10:03 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 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
  •