If Saturday, +2. If Sunday, +3

Any other way as in what?

What is exactly required which this function is not giving?

Deep Dave has a good question. You could do it this way,...

Formula:

=IFERROR(INDEX({2,3},MATCH(1,--((WEEKDAY(A1,2))={6,7}),0)),1)

but why would you want to?

Or are you seeking something like this?

=IF((WEEKDAY(TODAY(),2)=6),TODAY()+2,IF((WEEKDAY(TODAY(),2)=7),TODAY()+3,TODAY()+1))

This is what I understand from your Post Heading "If Saturday, +2. If Sunday, +3"

Often people want +3 on a Friday because they want the next working day, so to get the next working day after today you can use WORKDAY function, e.g.

=WORKDAY(TODAY(),1)

......or if you genuinely want to replicate your quoted formula try using CHOOSE like this:

=CHOOSE(WEEKDAY(TODAY()),3,1,1,1,1,1,2)

Or another way.

=LOOKUP(WEEKDAY(A1,2),{1,6,7},{1,2,3})