excel formula to get start of year
I have a cell named currentMonth. It contains a date, ie, "7/1/2011".
I want to place a formula in another cell, such that this cell will contain the value Jan 1 for the year of currentMonth. So in this example, the second cell will contain the value "1/1/2011". This is kind of what I mean, although it doesn't work:
="1/1/" + YEAR(currentMonth)
This second cell will also need to be formatted as a date.
I want to place a formula in another cell, such that this cell will contain the value Jan 1 for the year of currentMonth. So in this example, the second cell will contain the value "1/1/2011". This is kind of what I mean, although it doesn't work:
="1/1/" + YEAR(currentMonth)
This second cell will also need to be formatted as a date.
Last Comment
twohawks
currentMonth needs to be a valid date, and not just text.
Please try =Date(year(today()),1,1)
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect! Thanks.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
