Monthly Archives: June 2013

Excel – Using absolute cell references in SUMIF, COUNTIF, SUMIFS, COUNTIFS, etc

When you are using a function such as COUNTIF, the syntax is =COUNTIF(Criteria_range, criteria). In general the criteria needs to be enclosed in double quotes. What happens if you want to reference a cell as part of your criteria? Say, … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Changing Excel date from ddmmyyyy to dd/mm/yyyy

I was asked the other day about changing the date format in Excel from ddmmyyyy to dd/mm/yyyy. I tried using custom formatting without success. Assuming that the first date to be converted is in cell A2, I used the following … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | 2 Comments