Formula Needed for First Day of First Month of Present Year; Last Day of Last Month of Present Year

[Aimee S.]

Hey Folks.

I am specifically looking for a formula that is smart enough to know what the current date is, and populate in the formula cell the first day of the present year (e.g. this year it would be 1/1/2015, but next year the formula would automatically change that to 1/1/2016 and so forth).

I also need one that produces the last day of the present year along those lines.

I looked/snooped around this site a bit and found plenty where there is a reference to an existing date cell, but nothing self contained and dynamic enough to update with each passing year.

Thanks!

 

[gaz_chops]

Try these where A2 has the date, or change A2 to today()
1st day
=DATE(YEAR(A2),1,1)
Last
=EOMONTH(DATE(YEAR(A2),1,1),-1)

 

[SpillerBD]

=DATE(Year(NOW()),1,1)
=DATE(Year(NOW()),12,31)

You can also use TODAY instead of NOW...

 

[Aimee S.]

Thanks Gaz, but I don't have a date to reference. Spiller - that works perfectly. Thank you!

 

[gaz_chops]

Thanks Gaz, but I don't have a date, just need whatever the dates are via formula no matter what the present year. Spiller - that works perfectly. Thank you!

I edited it, change A2 to be today()