Home |
Search |
Today's Posts |
#1
|
|||
|
|||
First date of next month?
I have a cell where I put a date A1. I need a formula where it will
produce the first date of the next month. Thanks for any help. |
#2
|
|||
|
|||
=DATE(YEAR(A1),MONTH(A1)+1,1)
-- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200507/1 |
#3
|
|||
|
|||
=DATE(YEAR(a1),MONTH(a1)+1,1)
******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Randy" wrote in message oups.com... I have a cell where I put a date A1. I need a formula where it will produce the first date of the next month. Thanks for any help. |
#4
|
|||
|
|||
Try this:
=EOMONTH(A1,0)+1 Note: If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in Does that help? -- Regards, Ron "Randy" wrote: I have a cell where I put a date A1. I need a formula where it will produce the first date of the next month. Thanks for any help. |
#6
|
|||
|
|||
Thanks for the feedback, Randy
I'm glad "=EOMONTH(A1,0)+1" worked for you. -- Regards, Ron "Randy" wrote: Worked great thanks........... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
How do I copy only the month from a date | Excel Worksheet Functions | |||
Lookup the month in a date string 01/03/05 | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions |