Return a Future date based on criteria Weekdays only

Darla Brown

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

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

Paul Newcome

You would use the WEEKDAY function.

[Invoice Date]@row + 3

changes to

WEEKDAY([Invoice Date]@row, 3)

=Chris Palmer

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)))

Darla Brown

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

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

Paul Newcome

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

Darla Brown

LOL No Worries. Happens to me all the time!