If Saturday, +2. If Sunday, +3

[DavidRoger]

Hi,

Currently has this code.

Please Login or Register  to view this content.

Is there other way to do this?

[NeedForExcel]

Any other way as in what?

What is exactly required which this function is not giving?

[FlameRetired]

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

Please Login or Register  to view this content.

but why would you want to?

[NeedForExcel]

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"

[daddylonglegs]

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)

[FlameRetired]

Or another way.

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

[DavidRoger]

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)

You are right about the +3 on friday.

Please Login or Register  to view this content.

Never imagine you can have a function like this. Cut to the chase. Love it.

All here thanks.