How to Find most recent fridays of the week?

[ramees.pk (Ramees)]

Hi,
I am stuck at how to find most recent friday of the week.
Previous Sunday = Today.AddDays(- (Weekday(Today) - 1))
similarly , i am looking for previous friday code. Can anyone help me with this ?

[neetha]

Check this link Return date from previous week

Below expression returns Friday from previous week:

DayOfWeek WeekFriday = DayOfWeek.Friday;
int offsetDays = (int) WeekFriday - (int) DateTime.Now.DayOfWeek;
DateTime lastWeekFriday = DateTime.Now.AddDays(-7 + offsetDays);

or

DayOfWeek WeekFriday = DayOfWeek.Friday;
DateTime lastWeekFriday = DateTime.Now.AddDays(-7 + ((int) WeekFriday - (int) DateTime.Now.DayOfWeek));

[nimin (nimzz)]

Hi @ramees.pk,

@neetha’s solution is a perfect one if you would like to get the Friday of last week.

@ramees.pk

how to find most recent friday of the week.

In order to get the recent Friday, we need to make an alteration to @neetha’s code.

DayOfWeek WeekFriday = DayOfWeek.Friday;
int offsetDays = cint(WeekFriday) - cint(DateTime.Now.DayOfWeek)
If(offsetDays <=0)
then, DateTime lastWeekFriday = DateTime.Now.AddDays(offsetDays);
Else, DateTime lastWeekFriday = DateTime.Now.AddDays(-7 + offsetDays);

Warm Regards,
Nimin

[ramees.pk (Ramees)]

Thank you @neetha

[ramees.pk (Ramees)]

Thank you so much @nimin for your help !!