โ๏ธPlease Like ๐ and Subscribe ๐ My Channelโ๏ธ
Good Day! Oppadu comes back!
In this lecture, below 6 example will be explained.
1. Extract Year/Month/Day/Weekday from the date.
2. How to change Text to Date at once (without function)
3. How to calculate replacement date and alert once date is passed.
4. How to check probation period and salary promotion date.
5. How to count actual working days except Weekend and Public holiday.
6. How to calculate the number of years and month of each employee.
โฌ Free Example Files & E-Books are available!
/oppadu.com/์์
-๋ฌด๋ฃ-๊ฐ์/์์
-๋ ์ง-ํจ์-์ด์ ๋ฆฌ/
โฌ Free Educational Material related to this Post
์์
๋ ์ง ํจ์ ์์ฉ ๊ณตํด์ผ ์๋ํ ๋ฌ๋ ฅ ๋ง๋ค๊ธฐ :: โข ์์
๋ฌ๋ ฅ ๋ง๋ค๊ธฐ, ๋๊ตฌ๋ ์ฝ๊ฒ ๋ง๋๋ ...
์์
OFFSET ๋์ ๋ฒ์ ๊ธฐ์ด ๊ฐ์ :: โข ์์
OFFSET ๋์ ๋ฒ์ ๋ง๋ค๊ธฐ ๊ธฐ์ด...
์์
DATE ํจ์ ์ฌ์ฉ๋ฒ :: oppadu.com/์์
-...
์์
DATEDIF ํจ์ ์ฌ์ฉ๋ฒ :: oppadu.com/์์
-...
์์
EDATE ํจ์ ์ฌ์ฉ๋ฒ :: oppadu.com/์์
-...
์์
EOMONTH ํจ์ ์ฌ์ฉ๋ฒ :: oppadu.com/์์
-...
์์
WEEKDAY ํจ์ ์ฌ์ฉ๋ฒ :: oppadu.com/์์
-...
โฌOppadu Excel Official Homepage
www.oppadu.com
โฌOppadu Excel Official Facebook & Instagram
bit.ly/Oppadu_F...
#ExcelDateFunction #ExcelCountWorkingDays #ExcelDateCalculation
โฌ Creative Commons music used in this video.
Good For You by THBD / thbdsultan
Creative Commons - Attribution 3.0 Unported- CC BY 3.0
creativecommons....
Music promoted by Audio Library โข Good For You - THBD (N...
ะะตะณัะทะณั ะฑะตั Count actual working days, Excel Date function mastering lecture | Oppadu Excel Function 2-1
ะัะบััะปะตั: 109