| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need formula to have date in cell B2 rounded to first of next mont
Creating a spreadsheet where I can enter an employee's DOH in one cell, and
want a formula to automatically show the first of the month following 60 days. IE: Cell A2 6/15/05 in cell B2 I put in =A2+60, and it will result in 8/15/05... but I need it to now "round up" if you will to state 9/1/05... Is there a formula that will do this???? HELP! :) -- Rebecca |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Range within one cell | New Users to Excel | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| addition to my date formula...required | Excel Worksheet Functions | |||
Threaded Mode
