Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2021-07-15 13:00:14 | ![]() 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
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.