[Solved] What is the excel formula to find the upcoming Saturday a month?

=EOMONTH(TODAY(),0)+7-WEEKDAY(EOMONTH(TODAY(),0)+7) If you want it based on the current date, find the next first Saturday: =TODAY()+7-WEEKDAY(TODAY()+7) This will find the next first saturday of the month. So on the 6th of this month it will return 2/9/2017 3 solved What is the excel formula to find the upcoming Saturday a month?

[Solved] Formula for unmatched row cell and display value in one column

Native worksheet formulas simply do not handle string concatenation well. Even the new string functions that are being introduced such as TEXTJOIN function¹ and the updated CONCAT function² have difficulty with conditional concatenation beyond TEXTJOIN’s blank/no-blank parameter. Here are a pair of User Defined Functions (aka UDF) that will perform the tasks. Function udfUniqueList(rng As … Read more