Subtract Dates In Excel | Subtract Years, Months and Days
Тәжірибелік нұсқаулар және стиль
Download the featured file here:www.bluepecantraining.com/wp-...
In this Microsoft Excel tutorial I demonstrate how to subtract two dates.
00:00 Introduction
00:43 Calculate the number of days between two dates
01:27 Calculate the number of completed months between two dates
01:59 Calculate the number of completed years between two dates
02:18 Calculate the number of years, months and days between two dates
02:39 Calculate the number of months excluding completed years
03:01 Calculate the number days excluding completed years and months
04:54 Concatenate Y,M,D into one text string
Пікірлер: 10
Excellent Chester. DATEDIF, an important function in Excel. Great tutorial!!!
Thank you sir
Thank You
Is there any way to calculate weeks and days that automatically updates based on today's date?
How Can I insert the function of datedif? because it is not in the program.
V Good
This is weird. I do exactly the opposite. Based on a date selected from a calendar I populate 7 columns with: year, monthName, monthNo, DayName, DayNo, WeekNo, then I compose the date as a string of all. All in VBA for Excel-2010. Yup. The 2010.
How about if i want to add & subtract 2 years 10 months 21 days 5 years 5 months 15 days ___________________________ Answer?
@jeanegaboy548
3 ай бұрын
anyone can answer to this question?
I get the error message "there is a problem with this formula" Strange