0

I’m trying to find a way in Google Sheets to list the dates for the next 5 working days. I’ve got it to show me the next working week, however as today is a Wednesday ideally I would like the date for tomorrow and Friday, and then Monday Tuesday Wednesday.

I’m thinking it’s probably simple and I need to change my set up as at the moment I have mon-Friday listed and I wanted the dates out of the way and just the relevant data to filter through via lookup ... but I’m not sure if it’s even possible.

1
  • Welcome to Web Applications. Show the formulas that you tried and add a brief description of your search efforts as is suggested in How to Ask. – Rubén Mar 31 at 15:04
0

Try following formula:

=ARRAYFORMULA(WORKDAY(TODAY(),SEQUENCE(5,1,1,1)))

WORKDAY() returns date after number of working days (in this case 5 and to make it a list SEQUENCE() is used) starting from TODAY().

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.