Youtube daily Jun 18 2018

hi everyone it's Mitchel from Sheetgo and today I'm going to teach you how to use

the weekday formula in Google sheets weekday formula speaks for itself as you can

find the weekday of a given date when using this formula so the formula will

give number of one till seven representing the days of the week so in

this case I want to find out the date entry so on which day was the first of

January 1994 let's find out so we're using the weekday formula which is

weekday first thing that I need to do is I need

to put in the date so the date is equal to G two and secondly I need to type

in the type for me it's type two as I want the workweek to start on Monday and

ends on Sunday if you type in one which is the default value the work week will

start on Sunday and ends on Saturday we also have type three which is equal to

type two but only it will appear in a zero till six so I'm using type two but

if you find this difficult please click on the link down below in the

description as this video is based on a blog post but for this video we're

using type 2 so pushing on enter and as you can see the first of January 1996 is

equal to six which corresponds to Saturday so let's find that out for all

of my employees so one corresponds to Monday two corresponds to Tuesday and so on and so on

so this is how I use the weekday formula I want to thank you for your time if you

liked the video please leave a like and goodbye

For more infomation >> How to use the WEEKDAY formula in Google Sheets - Duration: 1:49.

-------------------------------------------

X-Men: First Class (2011) Movie Clip #7 [4K] (+Subtitles) | CoolestClips - Duration: 1:56.

Still drinking champagne, Bob?

I will pass.

Okay, well, so much for the pleasantries.

I was wondering who you told about our little arrangement.

No one.

-He's telling the truth. -Good.

Well, I guess we're done here.

Let's wrap things up, shall we?

I knew better than to trust you.

Now, you let me walk out of here with my money,

or I will pull this pin, and we all die.

Go ahead. Pull it.

I'll do it, I swear to God.

No, you won't.

But I will.

You're one of them?

Very astute of you, Colonel Hendry.

You want to guess what I can do?

I've got the power to absorb energy. It keeps me young.

But that's the boring part.

The fun stuff is what I can do with it once I've got it.

For more infomation >> X-Men: First Class (2011) Movie Clip #7 [4K] (+Subtitles) | CoolestClips - Duration: 1:56.

-------------------------------------------

Rudy Giuliani Says Agents Investigating Trump Are "Wackadoodles" Who Belong In Mental Hospitals - Duration: 3:28.

Over the weekend, Rudy Giuliani appeared at a campaign event for Republican Congressional

candidate Dan Donovan up in New York.

And during his little stump speech for Donovan, he kind of went off the rails a little bit,

and decided to talk about the recently released Inspector General's report, and things very

quickly went off the rails from there.

Take a look.

Well, what they've been doing to them is heartless, it's cruel.

Horrific.

It's an investigation made up of a bunch of distorted human beings who cried ... Imagine

FBI agents and prosecutors crying when Hillary Clinton wasn't elected.

I think if I could get those pictures of them crying instead of investigating President

Trump, they should go to Bellevue.

Yes!

Whackadoodles!

[inaudible 00:00:53] What's going to happen?

I think "Whackadoodle" is actually the correct term, but I don't think it applies to any

of the agents that were listed in that Inspector General report.

"Whackadoodle," though, is a perfect descriptor for Rudy Giuliani himself.

This is a guy who cannot go out and give an interview as Donald Trump's lawyer without

implicating him in further criminal activity.

This is a guy who, when he was running for president, Joe Biden described it best as

his senses were composed of a noun, a verb, and the phrase "nine-eleven."

Rudy Giuliani is a one-trick pony who can only talk about nine-eleven because that was

the only time in his life he ever did something that was halfway decent.

If you look at the rest of his political career, if you look at his career as a private attorney,

or consultant, or whatever the hell he wanted to call himself during those years, he was

nothing but an absolute and complete scumbag.

And here he is slandering those people listed in the Inspector General's report, making

stuff up, baiting that little crowd to where you can hear in the video them chanting "Lock

'em up," as if members of the Trump administration and Trump campaign weren't the ones being

locked up right now.

But still, they believe somehow [Peter Struck 00:02:22], [Lisa Page 00:02:23], and any of

the other ones listed in there committed some kind of crime against the United States.

What Giuliani should've actually also mentioned during his little speech there was the fact

that buried in that IG report is the fact that there were Giuliani allies working at

the FBI offices at New York that were so anti-Hillary that they were the ones that made the whole

Anthony Wiener laptop thing resurface and essentially force James Comey to come out

a few days before the election and make that announcement.

Giuliani and his little lackeys are the ones that are the "Whackadoodles," the ones that

couldn't stand losing, the ones that were politically motivated and actually helped

change the course of the presidential election.

But, yeah, go out there!

Say that these people belong in psych wards.

Say that they're "whackadoodles," because most people in this country understand that

those are things that apply to you more than they do these FBI agents.

For more infomation >> Rudy Giuliani Says Agents Investigating Trump Are "Wackadoodles" Who Belong In Mental Hospitals - Duration: 3:28.

-------------------------------------------

Jenna Bush Hager On Mom Laura Lane Welch Bush's Immigration Comments: 'I'm Proud Of Her.' | TODAY - Duration: 2:51.

For more infomation >> Jenna Bush Hager On Mom Laura Lane Welch Bush's Immigration Comments: 'I'm Proud Of Her.' | TODAY - Duration: 2:51.

-------------------------------------------

Griffin Hits Rock Bottom! She's Now Plagiarizing Samantha Bee in Latest Attack on Melania - Duration: 2:32.

For more infomation >> Griffin Hits Rock Bottom! She's Now Plagiarizing Samantha Bee in Latest Attack on Melania - Duration: 2:32.

-------------------------------------------

¡Los panameños festejan aún en la derrota! | Un Nuevo Día | Telemundo - Duration: 3:08.

For more infomation >> ¡Los panameños festejan aún en la derrota! | Un Nuevo Día | Telemundo - Duration: 3:08.

-------------------------------------------

Los fanáticos del fútbol se levantan con #TundraPower | Un Nuevo Día | Telemundo - Duration: 1:52.

For more infomation >> Los fanáticos del fútbol se levantan con #TundraPower | Un Nuevo Día | Telemundo - Duration: 1:52.

-------------------------------------------

John Legend, Sara Beth Bareilles, Andrew Lloyd Webber Talk 'Jesus Christ Superstar' Success | TODAY - Duration: 3:34.

For more infomation >> John Legend, Sara Beth Bareilles, Andrew Lloyd Webber Talk 'Jesus Christ Superstar' Success | TODAY - Duration: 3:34.

-------------------------------------------

New buy of a car !!?? - Duration: 8:51.

For more infomation >> New buy of a car !!?? - Duration: 8:51.

-------------------------------------------

Desi Ghee Recipe - Home Made Deshi Ghee Technique - घी बनाने का 2 सबसे आसान तरीका - Duration: 5:42.

Desi Ghee Recipe

Desi Ghee Recipe at Home

Home Made Deshi Ghee Technique

make deshi ghee at home

deshi ghee making video

For more infomation >> Desi Ghee Recipe - Home Made Deshi Ghee Technique - घी बनाने का 2 सबसे आसान तरीका - Duration: 5:42.

-------------------------------------------

칫솔 소독 간단하게 해결하는 방법 4가지 ► Good Morning ► https://goo.gl/eSBPMk - Duration: 3:18.

For more infomation >> 칫솔 소독 간단하게 해결하는 방법 4가지 ► Good Morning ► https://goo.gl/eSBPMk - Duration: 3:18.

-------------------------------------------

Jaya Bachchan | REAL LIFE Family,Childhood,Wedding & PERSONAL PHOTOS | SOME GOLDEN UNSEEN MOMENTS - Duration: 3:53.

Jaya Bachchan | REAL LIFE Family,Childhood,Wedding & PERSONAL PHOTOS | SOME GOLDEN UNSEEN MOMENTS

For more infomation >> Jaya Bachchan | REAL LIFE Family,Childhood,Wedding & PERSONAL PHOTOS | SOME GOLDEN UNSEEN MOMENTS - Duration: 3:53.

-------------------------------------------

Tyler Perry Unites Haddish, Goldberg - Duration: 1:28.

For more infomation >> Tyler Perry Unites Haddish, Goldberg - Duration: 1:28.

-------------------------------------------

Long Detours In Northern Wisconsin After Heavy Rains, Flooding « WCCO - Duration: 1:14.

For more infomation >> Long Detours In Northern Wisconsin After Heavy Rains, Flooding « WCCO - Duration: 1:14.

-------------------------------------------

¡Los colombianos le ponen color y alegría a la copa! | Un Nuevo Día | Telemundo - Duration: 2:55.

For more infomation >> ¡Los colombianos le ponen color y alegría a la copa! | Un Nuevo Día | Telemundo - Duration: 2:55.

-------------------------------------------

Te mostramos los 3 mejores goles del mundial de Rusia | Un Nuevo Día | Telemundo - Duration: 1:26.

For more infomation >> Te mostramos los 3 mejores goles del mundial de Rusia | Un Nuevo Día | Telemundo - Duration: 1:26.

-------------------------------------------

🔴 LIVE 🔴 Raft | #1 | Guess who's back... - Duration: 8:30.

For more infomation >> 🔴 LIVE 🔴 Raft | #1 | Guess who's back... - Duration: 8:30.

-------------------------------------------

Te mostramos las 3 mejores tapadas del mundial de Rusia | Un Nuevo Día | Telemundo - Duration: 1:23.

For more infomation >> Te mostramos las 3 mejores tapadas del mundial de Rusia | Un Nuevo Día | Telemundo - Duration: 1:23.

-------------------------------------------

"I don't want to die." | 5 Life Lessons From the Abyss - Duration: 6:01.

"Hello!? Are you okay?!" she asked as I laid there in a puddle of my own sweat. I opened

my eyes and asked, "What happened?"​ She said she didn't know but asked if she should

call the hospital. I nodded. She then asked if I was able to move... so I lifted my arms

an inch before they slammed back down on the table, "Yes, but I have no energy." The thought

of what this could all mean started to frighten me. I said, "I don't want to die."​ ​She

didn't hear me because of the commotion in the cafe and because there was a bit of a

language barrier because I live here in Vietnam.​ ​The medics arrived quickly with a stretcher.

They checked my blood pressure, glucose level, and heart rate - all seemed normal, which

worried me even more. I then got lifted out of there like Maximus at the end of Gladiator.

Let's fast forward a few days and I'm sitting across from the neurologist. I had spent those

days in bed with a numb tongue and an aching back pondering the worst case scenarios…

epilepsy, cancer, heart disease, Parkinson's? I didn't understand how someone so young and

healthy can go through such an ordeal unless there was a deep underlying medical issue.

The neurologist asked me to recall the events that led to the seizure…

"It was a typical day. I had just finished my coffee and cocaine… kidding, coffee and

cake. As I was getting ready to leave I felt my heart flutter. This has been happening

on and off for the past several months. I decided to do a google search into what might

be causing this. The prognosis varied from nothing to imminent death. I'm an optimist

so I told myself it's probably nothing, but then I started to feel dizzy then nauseous.

I told myself, "Don't throw up.", "Don't throw up". I leaned back in my seat to take a deep

breath. I then saw flashes of lights and images and then every thing went black. I awoke in

a puddle of sweat." He recommended an E.E.G. (tests epilepsy). I took the test and sat

back down with the doctor. He said the results came back… normal. Thank god. He asked me

if I've ever lost consciousness before? I said 3 times. Once when I was robbed and knocked

unconscious with a pipe. And twice before that while giving blood. He said that I likely

fainted and then explained if one is out for too long one will go into a seizure, which

was the difference between this time and the other times I fainted. I wanted to kiss the

doctor because it was the first time in days where I didn't think I was dying. With any

major life event, I think it could be helpful to reflect upon the lessons learned so that

the event would not have passed in vain. These were costly lessons for me because I don't

have health insurance, but I give them to you free of cost and without the associated

back pain… My first lesson is that we should prepare to die. One of my regrets while lying

motionless on the stretcher was that I still had so much more I wanted to accomplish. At

this point in my life I feel like I'm in debt. I'm in debt to my friends, family, and society.

I want to pay back that debt with interest before I die because "For whom much is given

much is required." And if finances permit, I'd like to be frozen so that my last words

can be something badass like, "I'll be back!" Non-Conscious Being. The loss of consciousness

is an interesting concept to ponder. Isn't it our "consciousness" that makes us human?

I ponder if losing consciousness is similar to death? Flashes of light and images. Everything

goes black. Time no longer exists. I re-awake without knowing whether seconds or hours passed.

In that brief interval "I" no longer existed. My experience was similar to a guy who was

actually pronounced dead: "Asked about what he felt the moment he died, the Reddit interviewee

revealed that it was like as if someone had flipped the on/off switch… everything around

him went to black." Obviously I wasn't dead, but it doesn't seem farfetched for my experience

to be similar to it. The abyss wasn't painful, but with that said, my first impulse upon

reawakening was to say, "I don't want to die." Hey God, it's me… Anthony. I am an agnostic

who would like to think there's a god, especially during low moments. I find the lower we go

the higher we look for strength and support. As I went into the MRI machine I was asking

god for my brain to be okay and I promised I'll try harder to not to take his creations

for-granted. Thoughts are more powerful than you thought. I read that some people are able

to make themselves faint. I feel like now that I've experienced it so many times I can

probably do so too {call me Hollywood} by tunneling my thoughts on a stressor, which

makes me ponder if we have the power to lose consciousness then maybe we have the power

to maximize it? Embrace the black. Upon returning from the abyss I've had a greater appreciation

for the beauty and richness of life. We are all so inundated with notifications, advertisements,

emergencies that corrode the enjoyment of simple pleasures. Meditation seems the closest

thing to nothing. Imagine meditating for a full day in a dark room. The next day you

step outside you'll have a greater appreciation for the light. When we start to feel like

we're losing appreciation for simple pleasures then consider going into a metaphorical or

actual hole. With these lessons I hope we can appreciate the light a little more for

as long as we got it.