This formula will add leading zeros to a given number up to a specified number of total characters in the result.
How To Add Leading Zeros To A Number
read more
All Posts
How To Get The Percent Of The Year Completed
This formula will return the percent of the year completed for a given date.
How To Test If A Date Is On A Weekend
This formula will test a given date to see if it’s a weekend (Saturday or Sunday) and return TRUE if it is a weekend and FALSE if it is not a weekend.
The Ultimate Guide To VLOOKUP
The VLOOKUP function allows you to search a value in the left most column of a range and return the corresponding value in a column to the right. The search is vertical from top to bottom and in fact, the “V” in VLOOKUP stands for vertical.
How To Get The Weekday Name From A Date
This formula will return the weekday for a given date.
How To Get The Percent Of The Month Completed
This formula will return the percent of the month completed for a given date.
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃
