I need a formula that will just subtract days from week days excluding any days on the week end.



Example: (weekdays only)
I tried the formula below
=IF(P3="s",WEEKDAY(W3-4))

P = S
W4 = 2/24

Result should be 2/18 got 1/5/00 as a result.

What am I missing?

Have a go at the WORKDAY function using a negative number as second argument

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Perfect,

I used WEEKDAY(W3)-4 and worked!!!


Thanks for you help.

Weekday ?????

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Sorry I meant:

I used WORKDAY(W3)-4 and worked!!!

This will not work as you have not entered the days!!