Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))))))))
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))))))))
Thanks I wrote something similar myself but rushed to also ask
Welcome Joseph...........