About 12,500 results
Open links in new tab
  1. Today Function Circular Reference Error - Microsoft Community

    Apr 12, 2011 · I am using Excel 2010. When I use the Today () function, Excel gives me a Circular Reference error. I can't work out what I am doing wrong?

  2. Highlight Cells Rules - calculate when a date is in date or out of ...

    Oct 22, 2024 · Hi everyone, We are tracking all of the staff training and we want to create some highlight cell rules. I can only find formulas that calculate with the =TODAY function and im not …

  3. I am trying to get the formula for excel that will provide a ...

    Oct 18, 2024 · I am trying to get the formula for excel that will provide a birthdate. Exact year plus months! For example: the child is 1 year and 4 months old I would like the answer to be in 1 …

  4. Problem with DATEVALUE () function. - Microsoft Community

    I have used the DATEVALUE () function in past versions of Excel, but I attempted today to use it with the the Office 2011 version and it returns #VALUE! In case I was using it wrong, I copied …

  5. Trouble with =MONTH (TODAY ())-1 in Excel - Microsoft Community

    Hi!I'm trying to calculate the average of monthly expenses for the year, except the current month. If I could just get =MONTH(TODAY())-1 to return a digit for the month previous to the current, all

  6. calculate difference between two dates in year, month and day in …

    Sep 26, 2011 · How to calculate the difference between two dates in years, months and days in excel. Let say first date is 01/15/1996 and second date is 09/26/2011. I want the answer in …

  7. No aparece función UNICOS (UNIQUE) en Excel 365

    Feb 7, 2023 · Buenas tardes. Tengo un suscripción familiar de Office 365. Tengo todo actualizado a la última versión, pero en Excel no me aparecen algunas funciones nuevas. Por ejemplo la …

  8. Extract nearest date to today's date from date range column

    Sep 19, 2024 · So my requirement is match search text in cell E1 in column A range and extract nearest due date to today's date from column C range. What function will give desired results, …

  9. Excel - copying sum function to another cell - Microsoft Community

    Jul 29, 2019 · When I use the Sum function in Excel for one cell I can no longer copy this formula to another cell; I have always been able to copy functions before today. How do I fix

  10. 为什么在将 Excel 工作簿中的一个工作表,移动或复制到另一个工 …

    为什么在将 Excel 工作簿中的一个工作表,移动或复制到另一个工作簿中时,会出现这样的提示:Excel 无法将工作表插入到目标工作簿中,因为目标工作簿的行数和列数比源工作簿少, 若 …