Hi guys! how can i achieve to add expression to read 1st of January of previous year?
i want to have only previous year only but need to be default to January 1st.
=DATEVALUE("January 1, DATEADD("Y",-1,YEAR(TODAY))" this won't work..
thanks in advance!
- Edited by jefnavarro Wednesday, September 11, 2013 5:08 AM