Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This seems like it should be simple but couldn't find the exact documentation for it.
I need to change a date so it becomes January 1st of the same year: 12/1/2013 becomes 01/01/2013, 05/05/2012 becomes 01/01/2012, 10/15/2011 becomes 01/01/2011 etc.
=date(floor(yearstart(DATE)))
yearstart= first ms of the year
floor=will round it
date=makes the integer to date
or =date('1/1/'&year(Date))
=date(floor(yearstart(DATE)))
yearstart= first ms of the year
floor=will round it
date=makes the integer to date
or =date('1/1/'&year(Date))
Yearstart function
Thanks - don't know how I missed that!