Formula Friday – Calculate The Date Of The Nth Weekday Of The Month
Hello Excellers welcome to more #formulafriday fun, today let's look at a query that is a actually a widely used calculation for a lot of different scenarios- calculating a date of a certain weekday...
Formula Friday – Show A Zero Not Negative Number After Calculating Stock Items – Two Methods
Hey Excellers, one of my favorite times of the week, #formulafriday time!. Today let's look at avoiding Excel displaying a negative number after a calculation of stock items in an...
Hello and welcome again to #formulafriday. Time for some more formula fun on a Friday. Today we will be looking at using the NETWORKDAYS Function to work out how many days are left in a month...
Formula Friday – How To Quickly Identify A Circular Reference In An Excel Sheet.
Hi Excellers, welcome back to another blog post in my #formulafriday series. Today let's look at locating circular references in Excel really easily. Why would we need to do that?. Well, chances...
Formula Friday – How To Calculate Age From A Date Of Birth In Excel
Hi Excellers, time for some more #formulafriday fun. Again this week this blog post is based on a question I was asked by a subscriber a few weeks ago and I thought it would be a good share it on...
Hi Excellers, time for some more #formulafriday fun. This blog post is based on a question I was asked by a subscriber a few weeks ago and I thought it would be a good share it on...