Notifications
Clear all
Excel
2
Posts
2
Users
0
Reactions
235
Views
Topic starter
Great news...I figured it out. ="01/01/"&YEAR(TODAY()) will create the result and allow calculations. Thank you!
Good morning,
Any help on this would be great. Need to have January 1st with current year for calculation purposes. Just wondering if there is a better way?
| First day of current year (Currently entered manually): | 1/1/2018 | ||
| Want field B2 to changed to 01/01/2019 as of January 1st for calculation reasons. I need to do this using a formula so my macros also put it to the first day of current year. | |||
| First day of current year (Using formula) | 01/01/2018 | ||
| Formulas | |||
| Current Year | 2018 | ||
| January 1st of Current Year: | 01/01/2018 | ||
Posted : 28/12/2018 8:53 am
Hi Troy,
This will return the 1st Jan of the current year:
=DATE(YEAR(TODAY()),1,1)
I don't recommend nesting this in lots of formulas because the TODAY function is volatile and will recalc every time you edit a cell, change a row height etc.
You'd be better to create a named range (which is really a named formula) and then use the name in your formulas, or place it in a cell and reference the cell.
Mynda
Posted : 28/12/2018 7:13 pm
