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!
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!