Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 19th 05, 10:09 PM
RamseyR
 
Posts: n/a
Default 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   Report Post  
Old October 19th 05, 10:43 PM
bpeltzer
 
Posts: n/a
Default 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   Report Post  
Old October 19th 05, 10:53 PM
RamseyR
 
Posts: n/a
Default 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   Report Post  
Old October 20th 05, 08:28 AM
ScottO
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Range within one cell Cachod1 New Users to Excel 5 October 18th 05 03:30 AM
Year-to-date year to date formula Philm Excel Worksheet Functions 1 October 7th 05 02:50 AM
Need to use IF formula with a Date cell Eric Mc Excel Worksheet Functions 2 June 8th 05 12:38 AM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
addition to my date formula...required Juco Excel Worksheet Functions 5 January 30th 05 12:48 PM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017