This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
HI MY FORMULA BELOW HAS ERROR, “could not be parsed due to exception:
Sequence contains no elements.” IF ( (LEFT(MID(
CONCATENATE(TEXT(YEAR(TODAY())&””),"-", IF(LEN(TEXT(MONTH(TODAY())))=2,
TEXT(MONTH(TODAY())), CONCATENATE(“0”,TEXT(MONTH(TODAY()) ))...