Forum Discussion
Anonymous
Oct 11, 2018I need help writing a complex formula involving dates
Hello! I am trying to work on a project that has thousands of dates that i need to set up as MM/DD and currently i have them as MM/DD/YY. Is there a function on excel that helps me do that auto...
Detlef_Lewin
Oct 11, 2018Silver Contributor
Hi
Format a date the way you want
Change the date system, format, or two-digit year interpretation
Your formula is a simple subtraction:
=A1-10