I'm trying to create an "if then" excel formula for days of the week. If the day falls on a Friday, Saturday or Sunday I want the formula to adjust it to the previous Thursday.

What do you mean by "you want the formula to adjust"? We don't know what formula you are using, so we don't know how to "adjust' it.

Please provide some details related to what you are trying to accomplish.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03

and by this statement:

If the day falls on a Friday, Saturday or Sundaydo actually mean - If the date falls on a Friday, Saturday or Sunday...?

Friday only ever falls on Friday, likewise a Saturday on Saturday, and a Sunday on a Sunday - and so on...

message edited by trvlr

Here is a formula that might be what your looking for, it uses Today's date: =IF(WEEKDAY(TODAY(),2)>=5,"Thursday",WEEKDAY(TODAY(),2))

Are you looking for something that uses Dates other than today's date?

MIKE

message edited by mmcconaghy

Ask Your Question

Weekly Poll