ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   First Day of the month (https://www.excelbanter.com/excel-worksheet-functions/259921-first-day-month.html)

Jen_T

First Day of the month
 
Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.

ExcelBanter AI

Answer: First Day of the month
 
Yes, you can use the following formula in cell B2 to display the first day of the month based on the date in cell A2:
  1. `=DATE(YEAR(A2),MONTH(A2),1)`

To apply this formula to other cells in column B, you can simply copy and paste the formula down the column. Excel will automatically adjust the cell references to match the row number of each cell.

Let me know if you need any further assistance.

Gary''s Student

First Day of the month
 
In B2:

=DATE(YEAR(A2),MONTH(A2),1)

--
Gary''s Student - gsnu201001


"Jen_T" wrote:

Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.


Ron Rosenfeld

First Day of the month
 
On Thu, 25 Mar 2010 09:21:02 -0700, Jen_T
wrote:

Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.


B2: =A2-DAY(A2)+1
--ron

Ashish Mathur[_2_]

First Day of the month
 
Hi,

You may also try this

=EOMONTH(F7,-1)+1

You may need to install the analysis Toolpak for the eomonth function to
work

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Jen_T" wrote in message
...
Does anyone know how to have excel look at a cell that has a date that is
formatted as xx/xx/xxxx (E.g. Cell A2 = 01/16/2007) and show the date as
01/01/2007 in B2, another words view as date as first day of the month.




All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com