I want to automate the next weekday function, which I manually update now. I use the 9/28/2022 date format, which is a Wednesday. I would like the cell to automatically pick the next Friday, in this example would be 9/30/2022, and display the date 9/30/2022, not the text Friday. If the cell shows 9/30/2022 I would like the cell to display the next Monday. I've been playing around with IF and Weekday with no success yet. Thank you for your time and consideration.
Last edited by WyoMan; 09-28-2022 at 02:13 PM.
How aboutFormula:
Please Login or Register to view this content.
Thank you Fluff13. I'm working with it. Let me see if I understand: A2 is the Start Date, or cell reference; 1 is Days (not sure what this means), and "1110110" seems to be the days of the week. If I want to manipulate the dates displayed, how do I accomplish that? For example, say I want to show a Tuesday, Thursday, Saturday date?
The first position is Monday, the second is Tuesday, ..., the last is Sunday.
0 means Weekday; 1 means No weekday (Weekend day).
If you want to show Tuesday, Thursday and Saturday date, please try:Formula:Please Login or Register to view this content.
AWESOME!! Fluff13 and HansDouwe, you are rockstars! I am humbled by the help I have received on this forum. Thank you both very much!
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks