BenGrobler
New Member
- Joined
- Apr 19, 2021
- Messages
- 31
- Office Version
- 2019
- 2016
- Platform
- Windows
I have created a worksheet in excel that shows valid and expired licenses.
I have used DATEDIF between 2 dates to show how long it is until the license is expired in Months.
then based on that answer i used and if statement =IF(N8<3,"Urgent Attention Book For Training") to show a number in Months.
Once that number in Months reads 3 or less the sheet needs to send an email, please help with a vba code to automate this process.
Tee valid / expired dates is set manually
The main date is +today()
I have used DATEDIF between 2 dates to show how long it is until the license is expired in Months.
then based on that answer i used and if statement =IF(N8<3,"Urgent Attention Book For Training") to show a number in Months.
Once that number in Months reads 3 or less the sheet needs to send an email, please help with a vba code to automate this process.
Tee valid / expired dates is set manually
The main date is +today()