Looking for a fomula for today()+1 skipping weekends

wagmanm

Board Regular
Joined
Feb 26, 2013
Messages
141
Today()+1 works just fine but if it is a Friday I want it to return the date for Monday. Can anyone help me with this?

Thanks!
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
5,059
Office Version
  1. 2013
Platform
  1. Windows
wagmanm,

Maybe... =TODAY() +CHOOSE(WEEKDAY(TODAY()),1,1,1,1,1,3,2)

Hope that helps.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,708
Messages
5,524,431
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top