I have a calendar that I am working with in Excel and i need to make a row that shows the mm/dd/yy for the day so that i can use that in other formulas.
This is the template I am working with
calendar.PNG
The formula that populates the automatically updating days (dependent on the calendar year) is =IF(DAY(JanSun1)=1,"",IF(AND(YEAR(JanSun1+1)=CalendarYear,MONTH(JanSun1+1)=1),JanSun1+1,""))
How can I take this formula and populate a mm/dd/yy format in a row above the days that also automatically updates like the current formula?
Thanks in advance!!
Bookmarks