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 |
#2
|
|||
|
|||
Need formula to have date in cell B2 rounded to first of next mont
To always advance to the first day of the following month:
=DATE(YEAR(B2),MONTH(B2)+1,1) If the '=60' results in the first of a month, are you supposed to advance yet another month? If not, use =IF(DAY(B2)=1,B2,DATE(YEAR(B2),MONTH(B2)+1,1)) --Bruce "RamseyR" wrote: 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 |
#3
|
|||
|
|||
Need formula to have date in cell B2 rounded to first of next
Bruce...You are AWESOME!!! Thanks so much.
-- Rebecca "bpeltzer" wrote: To always advance to the first day of the following month: =DATE(YEAR(B2),MONTH(B2)+1,1) If the '=60' results in the first of a month, are you supposed to advance yet another month? If not, use =IF(DAY(B2)=1,B2,DATE(YEAR(B2),MONTH(B2)+1,1)) --Bruce "RamseyR" wrote: 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 |
#4
|
|||
|
|||
Need formula to have date in cell B2 rounded to first of next
Another way is:
=EOMONTH(B2+60,0)+1 Rgds, ScottO "RamseyR" wrote in message ... | Bruce...You are AWESOME!!! Thanks so much. | -- | Rebecca | | | "bpeltzer" wrote: | | To always advance to the first day of the following month: | =DATE(YEAR(B2),MONTH(B2)+1,1) | If the '=60' results in the first of a month, are you supposed to advance | yet another month? If not, use =IF(DAY(B2)=1,B2,DATE(YEAR(B2),MONTH(B2)+1,1)) | --Bruce | | "RamseyR" wrote: | | 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 |
Reply |
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 |