Hi everyone!
I'm trying to tweak a date field to have a default of 2
businessdays added to newly created records (based on Created Date) but need some help. Can anyone please advise how to make this work?
TODAY() + CASE(MOD(TODAY() - DATE(1900, 1, 6), 7),
5, 4,
6, 3,
2)
#Formulas
6 answers
Eric Burté (DEVOTEAM) 
Forum Ambassador
Hello @Mario Santellan, missed it was for a default value. Indeed the record does not exist yet in this case, so no CreatedDate. Replace indeed the DATEVALUE(CreatedDate) by TODAY(), as you have done in your previous post :
TODAY() +
CASE(
WEEKDAY(TODAY()),
5, 4,
6, 4,
7, 3,
2
)
Eric
