What is wrong with the way you ate doing it now? It is all on one sheet....
AliGW Yesterday, 09:22 PMHi there,
I need help creating a formula that calculates the date in column A, cell 4 with month and numerical day (Jun 01), and then in the rest...
Have query for 2022 Receipts. Want to add date col to the PVT showing date if red'd w/i last 4 days & qty col showing qty rec'd on that date. Can...
AgingRapidly 2022-05-17, 10:45 PMit will be better for others to understand your question with sample data including original data and expected result....
caabyyc 2022-05-16, 04:38 PM
Help with Date and Weekday Functions
In B4 drag copied down:
AliGW Yesterday, 09:27 PM=CHOOSE(WEEKDAY(B$1+ROWS($1:1)-1), "Su", "M", "T", "W", "Th", "F",...