Issue in Days Function
Hello there, I am Balaji, I hope you are all doing well. I am using Windows 10 in Dell Latitude 7480 Laptop. I am facing an issue using the "Days" Function. DAYS Function Explanation and Description mentioned in Excel Software: DAYS FUNCTION This article describes the formula syntax and usage of the DAYS function in Microsoft Excel. For information about the DAY function, see DAY Function. Description: Returns the number of days between two dates. DAY function This article describes the formula syntax and usage of the DAY function in Microsoft Excel. For information about the DAYS function, see DAYS Function. Description: Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31. Now, If I am using the "DAYS" Function to calculate the number of days between two dates. Suggest me Which Function should I use to get the correct answer. I am Looking forward to your guidance. Thank you.
3way Match- PR, PO, Receipt and Invoice
Hi folks, I have 10 worksheets, is it possible to use Excel or even Copilot to assist here. I have 10 excel worksheets in a workbook with raw data from PR, PO, Receipts and AP. Is it possible to have you relate the tables using a unique field (of our choice), and you create for me a new worksheet with 3-way match between PR, PO, Receipts and AP data. Is this possible for you to do?
Dax to find open status for more than 1 hour
Hi Team, I have the below table: Here I want to find that whether door is being open for more than 1 hour or not. The Status column shows whether door is open or not. CreatedOn column shows time duration. Could you please help me create a dax logic to achieve this? PFA file here B&M.pbix Thanks in advance! SergeiBaklan
Returning a cell reference.
I've searched through all the Excel functions and can't seem to find a way to return a cell reference from a formula if that makes sense. For example. I have 5 in cell A1, 10 in cell A2, 4 in cell A3 and 8 in cell A4. In another cell I have the formula MAX(a1:a4) and that will return 10 which is the largest number in the array. I would like to know if there is a function I can use to return the reference of the cell instead of the value so that the formula would return $A$2 or whichever cell contained the largest value in the array.
The Formatting got wrong!!!!!
Hey! Someeone please help me with this... I have few data sets with me and both of them have dates coloumn in it. So I wanted to syncronize the dates from one sheet to another so I copied both in one sheet. Since is a daily data of 3 years its difficult tally them as the formatting of one sheet was different. So I want to change the formatting same as sheet 1 but the formatting fuction changes only selective cells which does not make any sense. Follow the image below....
