I figured it out, I was to focused on Month and date and trying to exclude year. Simply needed to find day of the year and compare to current day of the year for desired result.
=AE11-DATE(YEAR(AE11),1,1)+1
I figured it out, I was to focused on Month and date and trying to exclude year. Simply needed to find day of the year and compare to current day of the year for desired result.
=AE11-DATE(YEAR(AE11),1,1)+1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks