that's all. How would you do that?
that's all. How would you do that?
Excel 1.0.1 (16.0.14326.20140) (Android)
Excel 2010 14.04.4760.1000
Try this: =WORKDAY.INTL(A1,1,"1111110")
=WORKDAY.INTL(TODAY(),1,"1111110")
or: =A1+8-WEEKDAY(A1)
Last edited by Phuocam; 07-27-2020 at 12:16 AM.
wow thanks. how did you perform that magic? or where's the 'thursday' in all that gibberish?
might you know offhand how to convert 1/7/00 to 7?
oh I got it. Number format
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks