Taking date from a string holding the day

I have the days in an excel dt, and I should take their dates for the current week and hold them in date type var
any ideas?

Hi @zhasmina.dimitrova

Please give some examples.


@supriya117 thank you for the fast response
for example in the column I have : Monday, Friday, Saturday.
I should convert the values and store them in date type variable, holding their dates for the current week.


So the input should be like only “sunday” or “monday” like that only or it also contains date and year?

Please refer this thread: