Guttmann1983
Board Regular
- Joined
- Jul 27, 2015
- Messages
- 181
Hi, I am trying to figure out where I am going wrong with the below formula
=IF(WEEKNUM([Demand Sent]=WEEKNUM(TODAY()-1),2,"Last Week",""))
I am trying to just return "Last Week" if the date in column "Demand Sent" was from last week (Mon-Sun)
=IF(WEEKNUM([Demand Sent]=WEEKNUM(TODAY()-1),2,"Last Week",""))
I am trying to just return "Last Week" if the date in column "Demand Sent" was from last week (Mon-Sun)