Hello,
I need a formula that will return yesterdays date like =today()-1 however if today is Monday i need it to return fridays date instead of sundays.
Hope this exlains it well enough.
Ciaron
Hello,
I need a formula that will return yesterdays date like =today()-1 however if today is Monday i need it to return fridays date instead of sundays.
Hope this exlains it well enough.
Ciaron
=if(weekday(today()=2),today()-3,today()-1)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Yes thats perfect thank you very much!
try =TODAY()-1-IF(WEEKDAY(TODAY(),2)=1,2)
--------------------------------------------------------------------------------
Please click on the small star icon below the post if the response helps
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks