temp3

CASE DAYOFWEEK(`日時`)
  WHEN 1 THEN '日曜日'
  WHEN 2 THEN '月曜日'
  WHEN 3 THEN '火曜日'
  WHEN 4 THEN '水曜日'
  WHEN 5 THEN '木曜日'
  WHEN 6 THEN '金曜日'
  WHEN 7 THEN '土曜日'
END

COUNT(DISTINCT `社員コード`)
*
COUNT(DISTINCT CASE
    WHEN DAYOFWEEK(`日時`) BETWEEN 2 AND 6 THEN DATE_FORMAT(`日時`, '%Y-%m-%d')
END)
*
2

COUNT(DISTINCT `社員コード`)
*
COUNT(
  DISTINCT CASE
    WHEN DAYOFWEEK(DATE(`日時`)) BETWEEN 2 AND 6
      THEN DATE(`日時`)
  END
)
*
2

SELECT A.社員数, B.営業日数
FROM
  (SELECT Count(*) AS 社員数
     FROM (SELECT DISTINCT [社員コード]
           FROM [クエリ１]) AS X) AS A,
  (SELECT Count(*) AS 営業日数
     FROM (SELECT DISTINCT DateValue([日時]) AS 日付
           FROM [クエリ１]
           WHERE [日時] IS NOT NULL
             AND Weekday(DateValue([日時]), 2) BETWEEN 1 AND 5) AS Y) AS B;

SELECT A.社員数, B.営業日数
FROM
  (SELECT Count(*) AS 社員数
     FROM (SELECT DISTINCT [社員名]
           FROM [クエリ１]) AS X) AS A,
  (SELECT Count(*) AS 営業日数
     FROM (SELECT DISTINCT DateValue([年月日]) AS 日付
           FROM [クエリ１]
           WHERE [年月日] IS NOT NULL) AS Y) AS B;

DATE(CONCAT(
  SUBSTRING(`列名`, 1, 4), '-',
  LPAD(SUBSTRING(`列名`, 6, LENGTH(`列名`) - 6), 2, '0'), '-',
  '01'
))

=SUM(INDIRECT(ADDRESS(4,COLUMN())&":"&ADDRESS(ROW()-1,COLUMN())))

Regex.Match(target_Time, "\d{1,2}時\d{2}分\s*[〜～]\s*(翌日)?\d{1,2}時\d{2}分").Value

extractedTime = System.Text.RegularExpressions.Regex.Match(
    targetLine,
    "\d{1,2}時\d{2}分\s*～\s*\d{1,2}時\d{2}分"
).Value

Array.FindIndex(lines, Function(l) l.Trim().StartsWith("7/7"))

inputText.Split(
  New String(){ Environment.NewLine },
  StringSplitOptions.RemoveEmptyEntries
)

pattern = "(?<=" & dateStr & "\s*[\r\n]+)(\d{1,2}時\d{2}分\s*～\s*\d{1,2}時\d{2}分)"

直近一か月判定

CASE
  WHEN DATEDIFF(CURDATE(), DATE(`your_datetime_column`)) <= 30
    THEN 1
  ELSE 0
END

フォルダパスのみ修正版

"(?:[A-Za-z]:\\(?:[^\\\r\n]+\\)*[^\\\r\n]+)|(?:\\\\(?:[^\\\r\n]+\\)*[^\\\r\n]+)"

フォルダパスとファイルパス

"(?:[A-Za-z]:\\(?:[^\\\/:*?""<>|\r\n]+\\)*[^\\\/:*?""<>|\r\n]+)|(?:\\\\(?:[^\\\/:*?""<>|\r\n]+\\)*[^\\\/:*?""<>|\r\n]+)"

テスト用

(?:[A-Za-z]:[\\/][\w\-\$\.\\\/]+)|(?:\\\\[^\s]+)

=AND(ISBLANK(C11)=FALSE,NOT(REGEXMATCH(TO_TEXT(C11), "^\d{8}$")))