Difference Between Two Dates In Excel -

Last update images today Difference Between Two Dates In Excel

difference between two dates in excel        <h3 class=Kipyegon Breaks Her Own World Record In 1,500m

India 234 for 2 (Abhishek 100, Gaikwad 77*, Rinku 48*) beat Zimbabwe 134 (Madhevere 43, Avesh 3-15, Mukesh 3-37, Bishnoi 2-11) by 100 runs

India's first step into a new era of T20 cricket began with a stumble on Saturday, but they dusted themselves off well and truly to close out the weekend with a portentous win headlined by their most futuristic player. Abhishek Sharma, who lit up IPL 2024 with his incandescent, all-intent displays at the top of the order, gave international cricket its first glimpse of his ability on Sunday, taking Zimbabwe apart with a 46-ball century, the joint third-fastest by an India batter in T20Is.

That effort led India to 234 for 2 - their second-highest T20I total away from home - and left Zimbabwe needing to pull off their highest successful chase - they had only once hauled down a target above 199. They didn't get anywhere near close, as India's vastly superior bowling attack made full use of a two-paced pitch while defending a total that was well above-par. The margin of victory - exactly 100 runs - perfectly summed up the contest.

A deceptive start

On Saturday, Zimbabwe had opened the bowling with Brian Bennett, deploying his offspin against India's left-hand debutant, and that had brought a first-over wicket-maiden with Abhishek out for a duck. The same match-up kicked off the second T20I after India opted to bat, and Abhishek got off the mark in international cricket off the first legal ball he faced, pulling it for six.

It was a sign of what was to come, but it also wasn't. International cricket isn't necessarily a better standard than the IPL, but it can be very, very different. This was a Harare pitch with a bit of spongy bounce and seam early on, and Zimbabwe's attack used it well in the powerplay to keep India to 36 for 1.

Shubman Gill fell in the second over, chipping Blessing Muzarabani straight to mid-on, and the towering quick was Zimbabwe's best bowler in the early stages, troubling Ruturaj Gaikwad in particular with his lift and movement in the corridor. Abhishek took time coming to grips with the conditions too, and at one point was batting on 27 off 23 balls.

Then he looked to clear his front leg and hit Luke Jongwe's nibbly medium-pace over the top, and miscued it high in the air over the mid-off region. Wellington Masakadza got under it, and put it down.

Abhi shakes the room

From that point on, Abhishek was unstoppable, clattering 72 runs in his last 23 balls at the crease, hitting five fours and seven sixes in that time. Suddenly, the conditions ceased to bother him. He was rocking back to marginally short balls and pulling with fierce power. He was stepping out and freeing his arms gloriously to loft over the covers. A modest Zimbabwe attack, suddenly, was looking like what it was.

There was another drop along the way, Tendai Chatara running to his right from long-off and getting only the heel of his palm to a lofted drive off Sikandar Raza, when Abhishek was on 77 off 40. Zimbabwe were in the firing line, though, and with all the batting India had in the dugout - they had left out the left-arm quick Khaleel Ahmed and included an extra batter, handing Sai Sudharsan his T20I debut - he was taking nearly every ball on. Abhishek wasn't worried about getting out - this is why he made such an impact in the IPL even though his longest innings of the season only lasted 28 balls - and on this day luck smiled on him.

Along the way, he left a couple of bowlers nursing vivid bruises. Dion Myers' slow-medium disappeared for 4, 6, 4, 6, 4 in the 11th over, the pick of the hits a monster pull that hit the roof beyond the leg-side boundary to bring up Abhishek's fifty. Then Masakadza, unfortunate both to have dropped Abhishek and to be a purveyor of left-arm orthodox, went for 6, 6, 6 in the 14th over - the last of them a one-handed swipe over backward square leg that brought up Abhishek's century - before a miscue off the next ball ended the onslaught.

Gaikwad and Rinku pile it on

Or not, because Zimbabwe still had six overs to bowl and India were in the mood now. Gaikwad's struggle against the conditions and the rust of playing his first competitive cricket since the IPL extended all the way until his 38th ball, when he brought up his fifty with a pulled four off Jongwe. He took Chatara apart in the next over, the 18th, hitting him for three fours and a six to eventually finish unbeaten on 77 off 47.

India's main source of end-overs carnage, however, was Rinku Singh, who had been unlucky to miss their World Cup campaign while boasting an average of 89 and a strike rate of 176.23 in 11 innings at the time the squad was announced. He was in his element here, promoted to No. 4 with the perfect entry point for his skills, slapping the sixth ball he faced for a charging six over the covers and finishing the innings with a four and back-to-back sixes off Jongwe, who ended with figures of 0 for 53 in four overs. Not what he may have anticipated when he induced Abhishek to miscue on 27.

Mukesh, Avesh and Bishnoi wrap it up

If Zimbabwe had any hope going into their chase, it lay in the composition of India's attack. Having picked the extra batter, they were playing only four frontline bowlers, which left four overs to be completed by part-timers Abhishek and Riyan Parag.

Abhishek isn't a part-timer in domestic cricket, and has plenty of variations to go with his stock left-arm orthodox, but he discovered how difficult bowling in the powerplay in an international game can be, conceding 19 in the second over with Bennett in an aggressive mood. Bennett took hold of Mukesh Kumar in the next over as well, hitting him for a pair of massive back-to-back sixes - over square leg and then down the ground - but he fell next ball.

That was the second wicket Mukesh had taken with an in-ducker, after one in the first over to bowl Innocent Kaia through the gate. That sort of seam movement, with a bit of inconsistent bounce thrown in, was a defining feature of Zimbabwe's powerplay: they scored 22 runs more than India did in that phase, thanks to Bennett's aggression, but they lost four wickets to India's one.

One of these summed up how challenging the conditions still were: a bouncer from Avesh Khan skidding onto Sikandar Raza as he shaped to hook, forcing him to fend a catch off the glove to the keeper.

Zimbabwe's innings continued to flounder after the powerplay, with Ravi Bishnoi looking particularly unhittable - Johnathan Campbell, sweeping and reverse-sweeping with increasing desperation, failed to put bat on five successive balls from him, and bottom-edged the sixth into his body. Wessly Madhevere batted from the start of the chase all the way to the 17th over, and made 43 off 39 balls. Zimbabwe were eventually bowled out for 134 with eight balls remaining, with Mukesh and Avesh bagging three wickets apiece and Bishnoi finishing with 2 for 11 from his four overs.

How To Calculate Difference Between Two Dates In Excel Datedif Function
How To Calculate Difference Between Two Dates In Excel Datedif Function
Calculate Difference Between Two Dates
Calculate Difference Between Two Dates
N424.5 ?resize=595%2C333&ssl=1
N424.5 ?resize=595%2C333&ssl=1
2626206da8e1fd960bbbe3c524809d18
2626206da8e1fd960bbbe3c524809d18
Add Years To Date In Excel
Add Years To Date In Excel
Maxres2 ?sqp= OaymwEoCIAKENAF8quKqQMcGADwAQH4Ac4FgAKACooCDAgAEAEYMyBPKH8wDw==&rs=AOn4CLBfxV7XztwGavHr8 BOhUIs LTCJA
Maxres2 ?sqp= OaymwEoCIAKENAF8quKqQMcGADwAQH4Ac4FgAKACooCDAgAEAEYMyBPKH8wDw==&rs=AOn4CLBfxV7XztwGavHr8 BOhUIs LTCJA
Maxresdefault
Maxresdefault
How To Calculate Time Difference In Excel Between Two Dates 16
How To Calculate Time Difference In Excel Between Two Dates 16
Maxresdefault
Maxresdefault
How To Calculate Difference Between Two Dates In Excel
How To Calculate Difference Between Two Dates In Excel
03 More Number Formats 600x580
03 More Number Formats 600x580
Maxresdefault
Maxresdefault
Enter 2023 To Extract The Year From The Date
Enter 2023 To Extract The Year From The Date
Maxresdefault
Maxresdefault
11 Date Tab 600x411
11 Date Tab 600x411
Addwork3 768x540
Addwork3 768x540
5
5
71.9
71.9
06 Select Date Format 400x238
06 Select Date Format 400x238
Type E2 2 365.webp
Type E2 2 365.webp
09b1bf71f007d54e17ef5248d323b52e
09b1bf71f007d54e17ef5248d323b52e
71.12
71.12
F3af15f227bfdd9e879ff6129e5d8353
F3af15f227bfdd9e879ff6129e5d8353
G7Cse
G7Cse
750b9d21a1f1614c3d4e8eea74905268
750b9d21a1f1614c3d4e8eea74905268
02 Start Date
02 Start Date
71.14
71.14
How To Change Date Format In Excel 768x432
How To Change Date Format In Excel 768x432
03 Start Date
03 Start Date
DATE Function Usage
DATE Function Usage
01 Sample Data Result 600x307
01 Sample Data Result 600x307
07 Complete Months Dateset
07 Complete Months Dateset
09 Start Date
09 Start Date
0fc8be06cfa1587cadc47eb60fe8ea22
0fc8be06cfa1587cadc47eb60fe8ea22
Excel Add Years
Excel Add Years