Entering dates in a worksheet confuses most Excel users. Nearly every user has faced a date format problem, which format should be used to enter date? Should we set the month first then day or other way? Which date separator to be used? Is it “/” or “-“? How will the date be parsed when different locale settings are applied? Unfortunately, Excel does not provide an embedded calendar function. Continue reading Popup Calendar Addin for Excel
Monthly Archives: January 2015
Calculate a Running Balance
Suppose you maintain an Excel workbook to record your income and expenses, and you want to know the current balance of cash in hand or bank balance at any given date. Continue reading Calculate a Running Balance