Invoicing is general utilizes of Excel as office tool, and complex utilizes of program, due to need of using Excel date formats and =EDATE () functions, both of which are bit counter intuitive. After you know how they work, they work fine, and are inside steady.

Instructions

Step 1

Enter date the work was completed in cell.

Step 2

Choose cell and right click. Choose "Format Cells".

Step 3

Choose "Number" tab, and ensure that "Date" is chosen as format for cell. If you entered date in Excel's current date formats, Excel will have "Date" chosen.

Step 4

Enter following formula in cell C12: "= EDATE (B12, 1)". Press "Enter." After press "Enter," formula will assess and display date that is one month after date given in cell B12.