how can I do the above but with year?
I have the following in bold would and need to see the following results:
[b]22/07/2009 [/b] 01/01/2010
[b]13/02/2006 [/b] 01/01/2007
[b]19/04/2015 [/b] 01/01/2016
please email a solution to the above.
Add Days to Date (add days to a given date. There are dozens of usually used formulas in the Formula Helper.)
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To round dates to nearest month, a formula can solve it.
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
Type this formula =MONTH(EOMONTH(A2,(DAY(A2)>15)+0)) into a cell, then press Enter key, and drag the autofill handle to the cells you need.
In the above formula, A2 is the cell you want to round date to nearest month, and 15 indicates if the day number is greater than 15, then the nearest month is next month, and if in reverse, the nearest month is the current month. You can change them as you need.
Round (Rounding numbers, round down/up, round to even without formulas.)