Get instant live expert help on I need help with next friday date

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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. Help Please
Solved by F. C. in 30 mins
=IFERROR(IF(TEXT(DATE(Calendar_Year,ROW($A1),1),"ddd")=LEFT(I$5,3),DATE(Calendar_Year,ROW($A1),1),IF(H6>=1,H6+1,"")),"") 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
Solved by S. A. in 24 mins