Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am using this line to show the date as of every Monday, but i'd like to show Friday's instead, how would I do that?
Thanks in advance
=Date(WeekStart(APP_LOGIN_DATE), 'MM/DD')
May be this
Last Week's Friday (Past Friday)
=Date(WeekStart(APP_LOGIN_DATE, 0, 4), 'MM/DD')
or
This Week's Fridat (Coming Friday)
=Date(WeekStart(APP_LOGIN_DATE, 1, 4), 'MM/DD')
May be this
Last Week's Friday (Past Friday)
=Date(WeekStart(APP_LOGIN_DATE, 0, 4), 'MM/DD')
or
This Week's Fridat (Coming Friday)
=Date(WeekStart(APP_LOGIN_DATE, 1, 4), 'MM/DD')
This worked thank you. could you please explain what the code is saying?
thanks
WeekStart function takes 3 parameters, one of which can be used to move the weekstart date up or down. So in order to make Friday the weekstart, I used 4
=Date(WeekStart(APP_LOGIN_DATE, 0, 4), 'MM/DD')
Also, look here: