Need a formula to say next day of week. For example, tab 2 in cell H2 says Saturday. Would you please enter a weekday formula in tab 2,cell H2 that will link from tab 1 cell H2?
Thanks,
Dee
Need a formula to say next day of week. For example, tab 2 in cell H2 says Saturday. Would you please enter a weekday formula in tab 2,cell H2 that will link from tab 1 cell H2?
Thanks,
Dee
Last edited by dlittle20; 05-04-2020 at 10:14 AM.
Perhaps on sheet 2
=H3 and format as "dddd"
or =TEXT(H3,"dddd")
Hi,
This should do what you ask.
Formula:Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks