Here are some problems that our users have asked and received explanations on
How do I solve the following in excel: if a date falls on either Sunday or Saturday, change this date to Friday date before this date. Example (Saturday)24/03/2018 is change to( Friday)23/03/2018 and Sunday 25/04/2018 is also changed to (Friday)23/03/2018.
Solved by E. H. in 11 mins
I have a cell (K1) that contains the current date which is updated automatically. If that date falls around the next to last Monday of any month (the Friday before -Thursday), I need cells K1:M4 as well as A36:M43 to be highlighted.
Solved by E. J. in 22 mins
I am working on a spread sheet and I need to do it by date
( monday - friday ) using sort - no problem. Then I would like to sort it by patient balance smallest to largest. When I add a level I loose the sort by date monday- friday.
Solved by F. C. in 30 mins
in the above formola i Can't change the rull for holiday(saturday@ monday) to thursday and friday.
Solved by K. Y. in 16 mins
Looking for a formula to see the average amount of times something is made throughout the course of the week (Monday-Friday) from date form and name of product