Solved I'm trying to create an if then excel formula for days

July 14, 2019 at 20:30:48
Specs: Macintosh
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.

See More: Im trying to create an if then excel formula for days

Reply ↓  Report •

#1
July 15, 2019 at 03:40:53
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


Reply ↓  Report •

#2
July 15, 2019 at 05:44:54
and by this statement:

If the day falls on a Friday, Saturday or Sunday

do 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


Reply ↓  Report •

#3
July 15, 2019 at 07:48:42
✔ Best Answer
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

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •
Related Solutions


Ask Question