WORKDAY.INTL Formula for specific days

[RoscoW88]

Good Morning,

I am need of some assistance.....

I was kindly assisted with a formula for WORKDAY.INTL previously on here and i need a slight adaptation for a new formula.

I have the working days 1001011 and i need a date/time returned for the next working day based on Today()

So for example today is 24/07/2023 so i would need a formula return of 25/07/2023 08:00
For Tuesday i would need Wednesday
For Friday i would need Tuesday

is this a possibility?

Thanks
Ross

[AliGW]

Is this what you mean?

=WORKDAY.INTL(TODAY(),1,"1001011")+8/24

Format results cells as dd/mm/yyyy hh:mm.

[Kaper]

Or for having time written "easy way":

Please Login or Register  to view this content.

[AliGW]

LOL! Easy if you happen to know the TIMEVALUE function!

[HansDouwe]

Another easy way:

Please Login or Register  to view this content.

[RoscoW88]

Now..... i wont disclose which on i used, but it worked perfectly!!

+Rep for all!

Thanks!!

[AliGW]

LOL! I think that's VERY diplomatic. Some of us are highly competitive ...

Glad to have helped.

[RoscoW88]

Absolutely understandable

Have a good one!

[AliGW]

You, too.

[HansDouwe]

Thanks for the feedback and rep . Glad to have helped.

[Kaper]

Nice to take a part in such thread.
Thanks for added reputation and for marking thread solved.

Have a good evening!