Round Price to the Nearest Nickel

If you want to avoid pennies, you can round prices to the nearest nickel using the following formula:

Calculating Number of Working Days

You can use the NETWORKDAYS() function in Excel to calculate the number of working days (excluding weekends) between and including two dates.