All Date formula in excel in hindi Full tutorial of datedif, edate, today etc.
Вставка
- Опубліковано 12 вер 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
So Useful Sir Thanks
Nice sir 👍👍👍👍👍👍 many many thanks
So nice
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.
❤️❤️thank you sir so much❤️❤️👍👍👍
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.
Excellent job sir
Excellent sir
Excellent 👌
Please suggest a formula in excel that a perticular date the amount will be automatically changed
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!
Nice video. New date and text join. Emonths. Heard first time.
Best explanation
So nice 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
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 दिन पहले कौन सी दिनांक थी ।
Sir एक ऐसा फार्मूला बताए , जिसमे की कोई भी date लिखे तो वह date अपने next, wednesday या saturday की date में convert हो जाए
Bestum best
Thanks sir..
Jagah pe line rukne ke liy ky karna hai
Super
sir agar Hume Conditions ke Sath Datedif ka formula lagana hai to kya kar
Sir,
In excel 2010 sheet formula lock same time sheet1,sheet2,sheet3 and sheet4,
Please reply
Regards
nice helpful
Sir mujhe date as 19-07-23 only day ko multiply kese kare Thank you
Nyc ,.,.,.,.,.,.,,.
Day pata kerne kaa tarika
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
Nice
Sir hamari date of birth se kese pata kare amara konsi din ko janam hua tha
Sir jo aap note pad 6trick aap bataye ho wo nahi ho raha hai
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??
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 24 hours ke baad agar time badta hai to 2 days kaise batayega plz. bataye
Dateif formula 2010 me nahi he,
Formula =old date - new date /365 *12, ye formula chalega
Hallo sir ak deta entari shikhana hai
30 घंटे के बाद क्या समय और डेट कैसै चेक करे।
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 formula correctly likha he firbhi #value!... Aisa error bata Raha he
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
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 how to set expiry ms word file?
KONSA FORMULA RAKHNA HAI DD/MM/YY OR OTHER ????
Dally date entery sir
sir date and time ko 24 hours main 1 day kaise lega
It is not dated if but date dif i.e. date difference..difference between date....
365 me nhi he Sir.
2 computer me try kiya
2010 work kiya hai sir
Nahi chal raha 2010 me. Mai bahut try Kiya.
How to calculate no of months in decimal from start date to end date
#VALUE!
error aa rha sir🙄
Nhi chal Raha hai date
Hi
500 Years chi date of Birth ata nahin
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
Very useful sir, thanks
Very nice sir
Nice