# Weekday formula question

Options

I have a formula in Excel where I need it to return the Monday date from the week in the Inception Week column. For example 3/9/18 is a Thursday, but 3/5/18 is the Monday of that week. This formula works good except when the Monday of that week has to switch back to the previous month, like with the 3/1/18 date, the Monday of that week was 2/25/18 and the formula errors. Any ideas what I need to add to this formula to get that Monday date to calculate correctly for a previous month?

Inception Week formula

=IF([Customer Since Date]87 = "In Process", "", (DATE(YEAR([Customer Since Date]87), MONTH([Customer Since Date]87), DAY([Customer Since Date]87) + 2 - WEEKDAY([Customer Since Date]87))))

• ✭✭✭✭✭✭
Options

=IF([Customer Since Date]87 = "In Process", "", DATE(YEAR([Customer Since Date]87), MONTH([Customer Since Date]87), DAY([Customer Since Date]87)) + 2 - WEEKDAY([Customer Since Date]87))

• ✭✭✭✭✭✭
Options

=IF([Customer Since Date]87 = "In Process", "", DATE(YEAR([Customer Since Date]87), MONTH([Customer Since Date]87), DAY([Customer Since Date]87)) + 2 - WEEKDAY([Customer Since Date]87))

• Options

Very cool Paul thank you. I had too many parentheses LOL

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

I also shifted one of the parenthesis to close out the DATE function before adding 2 and subtracting the weekday. This way you are doing the +/- to the date itself instead of to the DAY number.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!