Remember Me?

#1
October 19th 05, 10:09 PM
 RamseyR Posts: n/a
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
October 19th 05, 10:43 PM
 bpeltzer Posts: n/a
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
October 19th 05, 10:53 PM
 RamseyR Posts: n/a
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
October 20th 05, 08:28 AM
 ScottO Posts: n/a
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
| 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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Cachod1 New Users to Excel 5 October 18th 05 03:30 AM Philm Excel Worksheet Functions 1 October 7th 05 02:50 AM Eric Mc Excel Worksheet Functions 2 June 8th 05 12:38 AM MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM Juco Excel Worksheet Functions 5 January 30th 05 11:48 AM

All times are GMT +1. The time now is 08:10 AM.