Forum Discussion
Solved
Last Friday date
Hi, How can I get last Friday date in a Custom Column of Power Query please? Today is 28/07/2021 so last Friday date was 23/07/2021. Thanks
Found a solution on Desktop forum:
Date.AddDays(Date.From(DateTime.LocalNow()),-Date.DayOfWeek(Date.From(DateTime.LocalNow()),5))
Found a solution on Desktop forum:
Date.AddDays(Date.From(DateTime.LocalNow()),-Date.DayOfWeek(Date.From(DateTime.LocalNow()),5))