Find specific dates in the past

[#1]

Hi all,

Just a quick one about dates. Has anyone ever dealt with finding weekly dates automatically? I am looking to save in a variable last Friday's date for example.

Thanks

[kiranmanoharrode · Accepted solution]

use this expression,

It will give u last Friday's Date

=if(WeekDay(Today())='Mon',Date(Today()-3),

if(WeekDay(Today())='Tue',Date(Today()-4),

if(WeekDay(Today())='Wed',Date(Today()-5),

if(WeekDay(Today())='Thu',Date(Today()-6),

if(WeekDay(Today())='Fri',Date(Today()-7),

if(WeekDay(Today())='Sat',Date(Today()-8),

if(WeekDay(Today())='Sun',Date(Today()-9))))))))

[#3]

Thanks I wrote something similar myself but rushed to also ask

[kiranmanoharrode]

Welcome Joseph...........