kya excel sheet main koi aisa formula hi.. k aj maine 30 lekha to kal woh automatically 29 ho jaye?
kya excel sheet main koi aisa formula hi.. k aj maine 30 lekha to kal woh automatically 29 ho jaye?
Salam:
Can u explain a bit.
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
koi hi jo jawab dy saqy?
baat kuch samajh nahi ayi brother
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?
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
enter kar ka enter kar dain.Code:=today()-c_day
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.
Office 2003 m Insert k Menu m Name Manager k function hot e hain.
regards,
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,
Bookmarks