yes.
in date column we have value like “Friday” instead of date. For that I need to match the day("Friday) with Current day. Then Get the date of Day(Friday). Difference of current date with last date.
DateColumnMatch&Range2.zip (17.0 KB)
i think this is what you mean… if the day of the week matches today, calculate range from today to ‘Last’ date in days
yeah, Thank you
Hi @Djh
Thanks for the reply! I got the solution