Скачать или смотреть Excel formula date and time

Of course! Here are the essential Excel date & time formulas in short:

Basic Formulas

1. =TODAY() - Current date
2. =NOW() - Current date & time
3. =DATE(year,month,day) - Creates date from numbers
4. =TIME(hour,minute,second) - Creates time from numbers

Extract Parts

1. =DAY(date) - Get day number
2. =MONTH(date) - Get month number
3. =YEAR(date) - Get year
4. =HOUR(time) - Get hour
5. =MINUTE(time) - Get minute

Calculate Difference

1. =DATEDIF(start_date,end_date,"unit") - Difference between dates
· Units: "d" (days), "m" (months), "y" (years)

Useful Examples

· =TODAY()+7 - Date 7 days from now
· =DATEDIF(A1,B1,"d") - Days between two dates
· =EDATE(start_date,months) - Add months to date

Note: Excel stores dates as serial numbers, so you can do simple math like date1 - date2