Nested Formulas

rodel.policarpio

Hi, I am counting the number of days in a calendar month, my formula works until I get to August. Am I missing something or is there a limit on how formulas I can nest? Thanks

Here's my nested formula…

=IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "January"), "31", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "February"), "28", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "March"), "31", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "April"), "30", IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "May"), "31",

IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "June"), "30",

IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "July"), "31", "NA")))))))

bisaacs

Hey @rodel.policarpio,

What error are you getting? There's a 4000 character count limit for a cell, and you're only at 571 so you should be fine.

rodel.policarpio

Not sure what happened, but it works now. Maybe I just needed to refresh the browser or maybe a computer reboot. Thanks for the feedback, though. And good to know the character limit. Have a good day.