Add or Substract DAYS or WORKING DAYS or MONTHS or YEARS to or from a Date

Add or Substract DAYS or WORKING DAYS or MONTHS or YEARS to or from a Date

HomeOther ContentAdd or Substract DAYS or WORKING DAYS or MONTHS or YEARS to or from a Date
ChannelPublish DateThumbnail & View CountActions
Channel Avatar Chester Tugwell2021-07-15 13:00:14 Thumbnail
4,724 Views
If you have found this content useful and want to show your appreciation, please use this link to buy me a beer .
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you!
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/07/Add-Days-to-Date.xlsx

In this video I demonstrate how to :

1) Add or subtract calendar days from a date.
2) Add or subtract working days (wkend is Saturday and Sunday) using the WORKDAY function.
3) Add or subtract working days (wkend is Sunday) using the WORKDAY.INTL function.
4) Add or subtract working days (three day week: Mon, Tues, Wed) using the WORKDAY.INTL function.
5) Add or subtract a month from a date using the EDATE function.
6) Add or subtract a year from a date using the DATE, YEAR, MONTH and DAY functions.
————————

Please take the opportunity to connect and share this video with your friends and family if you find it useful.