All Date formula in excel in hindi Full tutorial of datedif, edate, today etc.
HTML-код
- Опубликовано: 21 авг 2024
- fully explain of date function in this video like today, dated if, edate, eomonth, date to text etc. result for expire date and year day or month calculate. so watch the video till end thanks
#dateformula #msexcel #advancedexcel
www.amazon.in/shop/computergyanguruji
MS Excel Videos
• Hindi English Dictiona...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
Nice sir 👍👍👍👍👍👍 many many thanks
So nice
Excellent job sir
So Useful Sir Thanks
❤️❤️thank you sir so much❤️❤️👍👍👍
Sir एक ऐसा फार्मूला बताए , जिसमे की कोई भी date लिखे तो वह date अपने next, wednesday या saturday की date में convert हो जाए
Excellent sir
Best explanation
Very nice sir
Excellent 👌
Very useful sir, thanks
Super
Nice video. New date and text join. Emonths. Heard first time.
Nyc ,.,.,.,.,.,.,,.
Bestum best
Please suggest a formula in excel that a perticular date the amount will be automatically changed
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
Nice
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
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 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.
nice helpful
Thanks sir..
Jagah pe line rukne ke liy ky karna hai
sir agar Hume Conditions ke Sath Datedif ka formula lagana hai to kya kar
Sir mujhe date as 19-07-23 only day ko multiply kese kare Thank you
Dally date entery 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
सर जीआज की दिनांक से पीछे के दिन कैसे निकाल सकते है। उदाहरण 12-05-2022 से 1111 दिन पहले कौन सी दिनांक थी ।
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,
In excel 2010 sheet formula lock same time sheet1,sheet2,sheet3 and sheet4,
Please reply
Regards
Hallo sir ak deta entari shikhana hai
Sir jo aap note pad 6trick aap bataye ho wo nahi ho raha hai
sir 24 hours ke baad agar time badta hai to 2 days kaise batayega plz. bataye
Sir hamari date of birth se kese pata kare amara konsi din ko janam hua tha
30 घंटे के बाद क्या समय और डेट कैसै चेक करे।
365 me nhi he Sir.
2 computer me try kiya
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
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....
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??
Nahi chal raha 2010 me. Mai bahut try Kiya.
How to calculate fig tenure 0 - 6 months
how to get month in decimal start date to end date not between of date sir please send formula
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
Sir formula correctly likha he firbhi #value!... Aisa error bata Raha he
Sir how to set expiry ms word file?
KONSA FORMULA RAKHNA HAI DD/MM/YY OR OTHER ????
2010 work kiya hai sir
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
#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
Hi
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
pagla hai
So nice sir
Nice