Forum Discussion
Help with Formula
Hello, I have a book of spreadsheets where each sheet is a month starting with June 2024. Within each sheet Column A is "Date" consisting of daily dates (e.g., 07/01/2024) and then Column D is "...
You do not mention which version of Excel you are using (or on which platform you are using it). If you are using Excel 365, Excel 2024, or Excel for the web, you can see the attached workbook for two possible solutions.
In the future, please attach a sample workbook (after removing sensitive information, of course!) to your post, or store it on a sharing service such as OneDrive or Google Drive or DropBox and include a link to it in your post. Forum members are more likely to develop solutions if they do not have to go through the additional work of recreating a workbook from images.