Why doesn't my IFS expression work?

Whats wrong here…

IFS(
WEEKDAY(TODAY())=7,TODAY()+2,
TIMENOW()>“12:00:00”,TODAY()+1,
TODAY()
)

With the IFS() you need to use pairs and the last one doesn’t have pair. Instead of writing TODAY(), write TRUE,TODAY()

3 Likes