# Return a Future date based on criteria Weekdays only

Overachievers

Hi,

I have this formula:

=IF([Billing Arrangement]@row = "Prepayment", [Invoice Date]@row + 3, IF([Billing Arrangement]@row = "Direct Bill", [Invoice Date]@row + 7, 0))

Can anyone give advice to correctly write this to show WEEKDAY? [Invoice Date] column would be the date column I would point to.

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

• Overachievers

Wait, sorry. I changed to WORKDAY and that worked. Thanks!

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

• ✭✭✭✭✭✭

You would use the WEEKDAY function.

[Invoice Date]@row + 3

changes to

WEEKDAY([Invoice Date]@row, 3)

• ✭✭✭✭✭

Hello @Darla Brown,

This should work for you make sure the formula where you place this has the column properties set to "Date"

=IF([Billing Arragement]@row = "Prepayment", WORKDAY([Invoice Date]@row, 3), IF([Billing Arragement]@row = "Directbill", WORKDAY([Invoice Date]@row, 7)))

• Overachievers

I added both what @Paul Newcome and @Mr. Chris put but now I'm getting #INCORRECT ARGUMENT. I'm sure I've missed a comma or parenthesis somewhere.

see below:

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

• Overachievers

Wait, sorry. I changed to WORKDAY and that worked. Thanks!

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

• ✭✭✭✭✭✭

Sorry about that. Brain was thinking WORKDAY but fingers were typing WEEKDAY.

• Overachievers

LOL No Worries. Happens to me all the time!

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!