Hello experts,
I have two columns L and M, which have starting date (L) and ending date (M) for certain events (format is mm/dd/yyyy). I want to write a VBA program which can filter these columns with dates, if they are from the current week or the coming week (week definition - Monday through Sunday). If we can do this using formulas in the file, like in a new column, I am OK with that as well, but I would need to incorporate that formula in the code as this process is in the middle of a really long workflow, which is being done with the help of vba. Thanks for your help.
I have two columns L and M, which have starting date (L) and ending date (M) for certain events (format is mm/dd/yyyy). I want to write a VBA program which can filter these columns with dates, if they are from the current week or the coming week (week definition - Monday through Sunday). If we can do this using formulas in the file, like in a new column, I am OK with that as well, but I would need to incorporate that formula in the code as this process is in the middle of a really long workflow, which is being done with the help of vba. Thanks for your help.