•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Return A Variable Day of the Week With a Variable Number of Days Between
Our take
Are you grappling with the challenge of determining shipping days based on event schedules? Many professionals face this dilemma when coordinating deliveries across multiple locations. By leveraging the power of AI-native spreadsheet technology, you can simplify this process. Instead of relying on complex nested functions, consider using the WEEKDAY function to dynamically calculate shipping days based on your event timeline. This approach not only enhances accuracy but also streamlines your logistics.
I'm creating a calendar for calculating when we need to ship materials to different locations. Our shipping day is Friday for anything that needs to be shipped at distance, but we have 2 locations where we can ship the day before our events. I had planned to use a nested xlookup to determine the number of days before an event when we need to ship and what day of the week it needs to ship, but I can't figure out how to make it work, as I haven't used the weekday function before. I have tried, but I just can't figure it out with multiple variables. Am I on the right track? How do I make this work?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience