Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas based on a date
Hello,
In cell A1, I have a date, say, May 10, 2003 In cell B1, I want to input a formula so that it returns the first of the following month, in this case June 1, 2003 If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003 in cell B1 Please help me out - Thanks Al M. |
#2
|
|||
|
|||
with analysis toolpak addin installed
=EOMONTH(E1,0)+1 -- Don Guillett SalesAid Software "atmbonda" wrote in message ... Hello, In cell A1, I have a date, say, May 10, 2003 In cell B1, I want to input a formula so that it returns the first of the following month, in this case June 1, 2003 If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003 in cell B1 Please help me out - Thanks Al M. |
#3
|
|||
|
|||
Try this
=DATE(YEAR(A1),MONTH(A1)+1,1) -- Regards Ron de Bruin http://www.rondebruin.nl "atmbonda" wrote in message ... Hello, In cell A1, I have a date, say, May 10, 2003 In cell B1, I want to input a formula so that it returns the first of the following month, in this case June 1, 2003 If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003 in cell B1 Please help me out - Thanks Al M. |
#4
|
|||
|
|||
Thanks, I tried and it worked. Thanks again.
Al Mb. "Don Guillett" wrote: with analysis toolpak addin installed =EOMONTH(E1,0)+1 -- Don Guillett SalesAid Software "atmbonda" wrote in message ... Hello, In cell A1, I have a date, say, May 10, 2003 In cell B1, I want to input a formula so that it returns the first of the following month, in this case June 1, 2003 If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003 in cell B1 Please help me out - Thanks Al M. |
#5
|
|||
|
|||
Thanks, I tried and it worked. Thanks again.
Al Mb. "Ron de Bruin" wrote: Try this =DATE(YEAR(A1),MONTH(A1)+1,1) -- Regards Ron de Bruin http://www.rondebruin.nl "atmbonda" wrote in message ... Hello, In cell A1, I have a date, say, May 10, 2003 In cell B1, I want to input a formula so that it returns the first of the following month, in this case June 1, 2003 If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003 in cell B1 Please help me out - Thanks Al M. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas based on a date
Where in your formula below would I indicate I want the last day of the six
month post the date put in the indicated Cell? Thank you for your assistance. -- Judy Rose Cohen "Ron de Bruin" wrote: Try this =DATE(YEAR(A1),MONTH(A1)+1,1) -- Regards Ron de Bruin http://www.rondebruin.nl "atmbonda" wrote in message ... Hello, In cell A1, I have a date, say, May 10, 2003 In cell B1, I want to input a formula so that it returns the first of the following month, in this case June 1, 2003 If it were Dec 1, 2002 in cell A1, I want the formula to return Jan 1, 2003 in cell B1 Please help me out - Thanks Al M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
What formulas are best for sorting by date? | Excel Worksheet Functions | |||
how do i set up a formulas with an if date? | Excel Worksheet Functions | |||
How do I change content of a cell based on date | Excel Worksheet Functions | |||
Hiding rows based on date | Excel Worksheet Functions |