It's useful for us. Sir if I want to exclude any particular date viz. Sunday from current to previous date, then how can it be done? So, please make a video for this purpose.
Sir plzz mere questions ka ans jarur dena. Mera sawal. X naam ka aadmi 1 Jan 24 ko 5 din leave jata hai to uski leave kab tak hogi ?? aur yadi leave 5 Jan tak hai aur 5 Jan ko friday hai to use 6 Jan 24 & 7 Jan 24 free leave mil jay. Ismei ek column mei date twice kese late hain.
Dear Sir Thank you for your computer gayan video, it's useful information but can you explain why u put 3 times mmm to convert in the day, month & year, please try to explain logic always, then easy understand the formula. Thank you!
sir as we see expiry date...i am getting the same date after 2 of 1 years say...10/3/2000 after 1 year it is coming same as 10/3/2001 by applying =cell+365 ...why so??
Suppose we have two types of entries in the sheet & we've to calculate the count of days between two dates. But the condition here is, in few rows we've dates in both the row, but in few rows we only have start date. We do have two formulas to find the accurate days. But Do we have any single formula which can be used in both the condition?
R/Sir, ap nay dates to dates ka din batlaye for exm: 35 days , but Sir for Exm: Agar ham ney 1.1.2021 amount liya 25.1.2021 return karna hai =25 days bantay hain ok ab ham ye file save karlatay hain or jab bhi ye file open karay maslan after 3 days to 32 days auto howna chainye, this should be? kindly help and explain
1. Return different values based on condition Supposing I am attend 500 calls in a month and I want to incentive the slab based on the following conditions: Result Score Slab1 0 - 50 2.50₹ Slab 2 51 - 100 3.50₹ Slab 3 101 - 150 4.50₹ Slab 4 151- Above 8₹ What will be total incentive by using Excel formula. Regards DHARMENDAR RANA
Day alag column me hai Month alag aur year alag column me se jab sabh ko ek column me karte hai to 0 nahi aata hai jaise 08/09/2024 to 0 nahi aata kewal 9 ata hai. Bataye
How to put data in one row like customer name, relationship manager, designation name, amt in one row in pivot table please tell sir it was my interview question please tell?
Nice sir 👍👍👍👍👍👍 many many thanks
So nice
❤️❤️thank you sir so much❤️❤️👍👍👍
Excellent 👌
Excellent sir
Best explanation
Excellent job sir
Nice video. New date and text join. Emonths. Heard first time.
Very nice sir
Sir aap manlo 25-01-2022 hai n 30 din baad ka date n us pe red color hua Ana chahiye kya woh ho Sakata hai agar yes toh pls suggest me thank u
Super
Very useful sir, thanks
Please suggest a formula in excel that a perticular date the amount will be automatically changed
Sir,
In excel 2010 sheet formula lock same time sheet1,sheet2,sheet3 and sheet4,
Please reply
Regards
Nyc ,.,.,.,.,.,.,,.
It's useful for us. Sir if I want to exclude any particular date viz. Sunday from current to previous date, then how can it be done? So, please make a video for this purpose.
Day pata kerne kaa tarika
Thanks sir..
nice helpful
Sir एक ऐसा फार्मूला बताए , जिसमे की कोई भी date लिखे तो वह date अपने next, wednesday या saturday की date में convert हो जाए
Sir plzz mere questions ka ans jarur dena. Mera sawal. X naam ka aadmi 1 Jan 24 ko 5 din leave jata hai to uski leave kab tak hogi ?? aur yadi leave 5 Jan tak hai aur 5 Jan ko friday hai to use 6 Jan 24 & 7 Jan 24 free leave mil jay. Ismei ek column mei date twice kese late hain.
sir agar Hume Conditions ke Sath Datedif ka formula lagana hai to kya kar
Dear Sir
Thank you for your computer gayan video, it's useful information but can you explain why u put 3 times mmm to convert in the day, month & year, please try to explain logic always, then easy understand the formula.
Thank you!
sir as we see expiry date...i am getting the same date after 2 of 1 years say...10/3/2000 after 1 year it is coming same as 10/3/2001 by applying =cell+365 ...why so??
Nice
Jagah pe line rukne ke liy ky karna hai
Suppose we have two types of entries in the sheet & we've to calculate the count of days between two dates.
But the condition here is, in few rows we've dates in both the row, but in few rows we only have start date.
We do have two formulas to find the accurate days. But Do we have any single formula which can be used in both the condition?
You can try this with AND / OR
R/Sir, ap nay dates to dates ka din batlaye for exm: 35 days , but Sir for Exm: Agar ham ney 1.1.2021 amount liya 25.1.2021 return karna hai =25 days bantay hain ok ab ham ye file save karlatay hain or jab bhi ye file open karay maslan after 3 days to 32 days auto howna chainye, this should be? kindly help and explain
yadi last date fix hai to update nahi hoga, last date mein "=today()" function use karen
sir 24 hours ke baad agar time badta hai to 2 days kaise batayega plz. bataye
सर जीआज की दिनांक से पीछे के दिन कैसे निकाल सकते है। उदाहरण 12-05-2022 से 1111 दिन पहले कौन सी दिनांक थी ।
Hallo sir ak deta entari shikhana hai
1. Return different values based on condition
Supposing I am attend 500 calls in a month and I want to incentive the slab based on the following conditions:
Result Score
Slab1 0 - 50 2.50₹
Slab 2 51 - 100 3.50₹
Slab 3 101 - 150 4.50₹
Slab 4 151- Above 8₹
What will be total incentive by using Excel formula.
Regards
DHARMENDAR RANA
Sir jo aap note pad 6trick aap bataye ho wo nahi ho raha hai
Sir mujhe date as 19-07-23 only day ko multiply kese kare Thank you
Dally date entery sir
Day alag column me hai Month alag aur year alag column me se jab sabh ko ek column me karte hai to 0 nahi aata hai jaise 08/09/2024 to 0 nahi aata kewal 9 ata hai. Bataye
How to calculate fig tenure 0 - 6 months
365 me nhi he Sir.
2 computer me try kiya
Sir hamari date of birth se kese pata kare amara konsi din ko janam hua tha
Sir how to set expiry ms word file?
sir date and time ko 24 hours main 1 day kaise lega
How to put data in one row like customer name, relationship manager, designation name, amt in one row in pivot table please tell sir it was my interview question please tell?
all field drag one by one in row selection area
2010 work kiya hai sir
Sir formula correctly likha he firbhi #value!... Aisa error bata Raha he
30 घंटे के बाद क्या समय और डेट कैसै चेक करे।
Dateif formula 2010 me nahi he,
Formula =old date - new date /365 *12, ye formula chalega
It is not dated if but date dif i.e. date difference..difference between date....
how to get month in decimal start date to end date not between of date sir please send formula
KONSA FORMULA RAKHNA HAI DD/MM/YY OR OTHER ????
Hi
Nahi chal raha 2010 me. Mai bahut try Kiya.
#VALUE!
error aa rha sir🙄
How to calculate no of months in decimal from start date to end date
Nhi chal Raha hai date
500 Years chi date of Birth ata nahin
pagla hai
Dear sir
please help
how to check month day by date
Example
15/1/2020 = 31
16/5/2020 = 31
4/6/2020 = 30
27-02-20
29-06-20
16-07-20
So Useful Sir Thanks
So nice sir
Nice
nice