NEED HELP WITH EXCEL FORMULA ABOUT TIMESHEET CALENDAR

Question

Hi everyone,Please help me to write a formula that will show only the schedules in each month.For example, If I selected the month of February in the dropdown it will show the events inputted in the table.Month = cell A2&nbsp;&nbsp;&nbsp;

nikolinode · Answer

kjade123&nbsp;With your permission, if I can recommend you, please always add specific information about your Excel version and operating system to your concerns. As well as, if possible or necessary, a file (without sensitive data) or photos. Information on where the file is, such as OnDrive or Sharepoint, is of advantage. In this way, you will come up with a proposed solution much faster and more precisely. This also makes it much easier for the other users to provide the help that they would like to offer you. It helps both :).&nbsp;Here is a link with information on how you can quickly find a solution that is most suitable for you.Welcome to your Excel discussion space!&nbsp;&nbsp;&nbsp;Thank you for your understanding&nbsp;NikolinoDEI know I don't know anything (Socrates)

kjade123 · Answer

Hi NikolinoDE,Thanks very much for your response.I am using Microsoft 365 MSO (Version 2303 Build 16.0.16227.20202) 64-bitfile is saved in OneDrive

nikolinode · Answer

kjade123&nbsp;A file (without sensitive data) of how the whole thing is structured would be an advantage and would help a lot to understand the whole thing better. If you cannot paste the file here, you can share OneDrive or googlesheets or any other website and the file (such as https://easyupload.io/).

kjade123 · Answer

Hi NikolinoDE,I tried to upload the file on the link you provided. Please let me know if you can access the file through the link below.https://easyupload.io/kuib88Regards!

nikolinode · Answer

kjade123&nbsp;Please look at the attached file.The formula you provided contains dates in a specific format: "1-Jan-2023;1-Feb-2023;1-Mar-2023;1-Apr-2023;1-May-2023;1-Jun-2023;1-Jul-2023;1-Aug-2023;1-Sep-2023;1-Oct-2023;1-Nov-2023;1-Dec-2023". However, it seems that you want to use this formula for data validation in Excel.&nbsp;The issue is likely that the format you are using is not recognized as a valid date format by Excel. Excel typically uses the Day-Month-Year format or the Month-Day-Year format, depending on the regional settings in Excel.&nbsp;To ensure that Excel recognizes the data as a date, you should adjust the format accordingly. Here is an example change for the format of the data in the formula:&nbsp;"01/01/2023;01/02/2023;01/03/2023;01/04/2023;01/05/2023;01/06/2023;01/07/2023;01/08/2023;01/09/2023;01/10/2023;01/11/2023;01/12/2023"&nbsp;By changing the date format to "DD/MM/YYYY" (Day/Month/Year), Excel should correctly recognize the data as dates and display them in the data validation.&nbsp;Please note that the exact date format may also depend on the regional settings in your Excel. Make sure that the format you are using matches the regional settings so that Excel can interpret the data correctly.&nbsp;

Forum Discussion

NEED HELP WITH EXCEL FORMULA ABOUT TIMESHEET CALENDAR

Share

Resources