Using a calculated column to output the day number for the last day of the current month. The current formula is:
=IF(LeapYear, WEEKDAY(CONCATENATE(MONTH(TODAY()),"/",CHOOSE(MONTH(TODAY()),31,29,31,30,31,30,31,31,30,31,30,31),"/",YEAR(TODAY()))), WEEKDAY(CONCATENATE(MONTH(TODAY()),"/",CHOOSE(MONTH(TODAY()),31,28,31,30,31,30,31,31,30,31,30,31),"/",YEAR(TODAY()))))
Occasionally this column is returning
#Name? and giving me some grief. I have yet to find a pattern to when/why it's returning this error. There is a daily workflow that updates this list item to maintain a this record as a reference for date information regarding the current week, month, etc.
From 10/11 to today, this has happened on 10/13 and 10/16. LeapYear is another calculated column.
Thanks in advance.