duedate

Hello Excel Gurus! First time poster here :) I am trying to set up a spreadsheet for a psychiatric provider to use to track when clients need to be seen. Ideally, I would like it to be the last name, first name, frequency, last seen date, needs to be seen date. I know how to do the basic last...

Hi All, Hoping someone can help with a conditional formatting question. <colgroup><col></colgroup><tbody> If the date completed is less than or equal to the date due, get the icon tick If the date completed is greater than the due date get the amber exclamation mark if a date of zero...

Hi all, I am trying to write a VBA to create an Outlook Appointment in a shared calendar. The below code creates an appointment, but in my own default calendar. I would appreciate any help anyone can provide, as I am struggle to find an answer. Sub CalendarEntry() Dim OutApp As Object Dim...

I have this macro to run in my workbook but is giving me an error, as a runtime 5 and it was working good in another computer but if I try in my is not working, this macro will filter everything for today's date only Sub CreditCard() Application.ScreenUpdating = False Dim DueDate As String Dim...

When I run this code it works for each iteration of the loop until the duedate pulls from a blank cell. How do I fix this or make it so it skips blank cells? It gives "Runtime Error 13 Data Mismatch" Sub CreateTask() Dim olApp As New Outlook.Application Dim olName As Outlook.Namespace Dim...