| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date = first day of next month
in
A B 1/19/2088 2/1/2008 2/20/2008 3/1/2008 1/23/2008 2/1/2008 What formula can I use in the B column to make this happen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date = first day of next month
=DATE(YEAR(A1),MONTH(A1)+1,1)
-- __________________________________ HTH Bob "Dylan @ UAFC" wrote in message ... in A B 1/19/2088 2/1/2008 2/20/2008 3/1/2008 1/23/2008 2/1/2008 What formula can I use in the B column to make this happen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date = first day of next month
Dylan @ UAFC wrote:
in A B 1/19/2088 2/1/2008 2/20/2008 3/1/2008 1/23/2008 2/1/2008 What formula can I use in the B column to make this happen There are several options. Try this one: =DATE(Year(A1),MONTH(A1)+1,1) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date = first day of next month
hi Dylan
You can use this =DATE(YEAR(A1),MONTH(A1)+1,1) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dylan @ UAFC" wrote in message ... in A B 1/19/2088 2/1/2008 2/20/2008 3/1/2008 1/23/2008 2/1/2008 What formula can I use in the B column to make this happen |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date = first day of next month
Try one of these.
If you have the Analysis ToolPak add-in installed... =EOMONTH(A1,0)+1 Format as Date Or: =DATE(YEAR(A1),MONTH(A1)+1,1) -- Biff Microsoft Excel MVP "Dylan @ UAFC" wrote in message ... in A B 1/19/2088 2/1/2008 2/20/2008 3/1/2008 1/23/2008 2/1/2008 What formula can I use in the B column to make this happen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Month in Date With Month in Header | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions | |||
| Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
![Dylan @ UAFC[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
