Replace value that between 2 date

Here's one way. The algorithm is in the code comments:

let

//Read in the Availability Table
    Source = Excel.CurrentWorkbook(){[Name="Availablity"]}[Content],
    Availability = Table.TransformColumnTypes(Source,{
        {"Product Name", type text}, {"Start Date", type date}, {"End Date", type date}}),

//Group by Product
//then create a list of all available dates for each product
    #"Grouped Rows" = Table.Group(Availability, {"Product Name"}, {
        {"Available", (t)=> 
            List.Combine(
                List.Generate(
                    ()=>[d=List.Dates(
                            t[Start Date]{0}, 
                            Duration.Days(t[End Date]{0} - t[Start Date]{0})+1, 
                            #duration(1,0,0,0)),
                         idx = 0],
                    each [idx] < Table.RowCount(t),
                    each [d=List.Dates(
                            t[Start Date]{[idx]+1}, 
                            Duration.Days(t[End Date]{[idx]+1} - t[Start Date]{[idx]+1})+1, 
                            #duration(1,0,0,0)),
                        idx = [idx]+1],
                    each [d]
            ))
        }}), 
        
//Read in the "raw" table
    Source2 = Excel.CurrentWorkbook(){[Name="raw"]}[Content],
    raw = Table.TransformColumnTypes(Source2,
        List.Zip({
            {"Store","Product","Order Date","Status"}, 
            {type text, type text, type date, type nullable text}}
        )),

//Join with the Available table and extract the List of Available dates for each product
    #"Join Available" = Table.NestedJoin(raw,"Product", #"Grouped Rows","Product Name","Available",JoinKind.LeftOuter),
    #"Available List" = Table.TransformColumns(#"Join Available", {"Available", each List.Combine([Available])}),

//Replace "Error" with "Create Memo" based on your logic
    #"Replace Error" = Table.ReplaceValue(
        #"Available List",
        each [Status],
        each if [Status] = "Error" and List.Contains([Available],[Order Date]) then "Create Memo" else [Status],
        Replacer.ReplaceValue,
        {"Status"}
    ),
    
//Cleanup
    #"Removed Columns" = Table.RemoveColumns(#"Replace Error",{"Available"}),
    #"Type Status" = Table.TransformColumnTypes(#"Removed Columns",{"Status", type text})
in
    #"Type Status"