MS Excel - Date Functions Part 1

Ncsr

Not working boss

Can we change date in every single sheet of Excel

Thanks 😊

You just gained a subscriber

What if I have to add 1 and a half month

Enjoyed your video. One question: I'm making a work schedule on EXCEL, on the date entries, how do I raise the st part? Example: Oct 21st.

Could you help me out !!! I have making a plan sheet which i want to determine to columns Plan & Actual. if Plan date is 21-08-2023 & Actual date 24-08-2023 then how it could be highlighted with color red or green color

Bhai ek baar date aur months different lekar formula use karke btao

Simple its

Great video 😃👍

Sir! In excel where is the gutter option for margins

APKA TEACHING KA TARIKA BAHUT HI SIMPLE HAI JO KI BAHUT ACCHESE SMJNE MAI HELP KRTA HAI ,THANKS.

Date calculation is not possible the way you said

1) 8h 30m 2) 3h 45m 3) 6h 50m....plz tell me formula to calculate this time for average.

Sir I used edate formula buy days are changing

Sir how to subtract today date to previous date in day and months?
Like :
1 Aug 2022 (previous date) and 13 feb 2023 (today date)
Answer : 6 months 12 days

march 22, 1899 and jan 10, 1983 what formula to get the age in years, month and days?

Hi, thanks for uploading this video and it is very useful for me.
One doubt : How to remove an ####### when subtraction formula is applied on a blank cell?

sir i need help one

you're a champ

If give date function examples 11.01.2022 but I find this date 01.11.2022 Pls how resolve this problam

Today Date i am watching .
=21-10-2022

it will be helps me in 2023 On job

Can you help me please , the bottom for turning back on the up left side is showing up on my excel sheet , how can I re add it please

How to extract only date when u have date month and year in Excel sheet?

thanks

Open 2 excel files side biside

Thank you so much sir

Mere me month - ki value right no a rhi h or na hi year ki a rhi h jab apko mera comment mile ap meko reply de dena

और यदि 35-40 दिन date में add करना है तो वो कैसे करेंगे

It could be error cause when we add 10 years then it will affect date also in future due to leap year

simply amazing

I WANT FORMULA - IF ANY CELL BLANK, UPTO TILL DATE THEN FILL CELL WITH COLOUR

Sir I try edate function but I don't get right answer? What should I do?I use this in excel 2007.

Tally karva do bhaiya

how to convert April 13, 2021 into 13-04-2021 in excel please help

Tq sir...

can we add 30 years in 10.01.2022 using EDATE function

When using Month function the format in result comes as '03-01-00' of the date 09-03-14. Can someone help?

sir your lesson screen not show clearly plz correct it tq.

Sir 10th ki marksheet par ek video bnado

Can I get the month and day to be two digits? or will Month and Day always be one (or two if over 9)

how slove problem 2022/xx/xx in date cell

How do you put in one cell (jan 1 to jan 7) and then make a formula that would calculate the next week start and end date in the next cell?
So the next cell would say (jan 8 to jan 14)

Cuteness k chkkr me sare vdos dekh dale 🙂❤️ aur seekh bhi lia