Excel Formula Problems

[santhu21]

I have two columns called


1ST column Calendar Date:16/02/2015


2nd Column Previous Day:Yes(Formula I am currently using if([calendar Date])=today1,"YES","NO").The 2nd column returns value based on the 1st column.


However , the problem I am getting is when I run the data on monday when we have calendar date(day on friday).So it is showing "NO" as formula only returns data for previous day.
So I want something like this
if(weekday=2 then [calendar Date])=today-3,"YES","NO")
else if(weekday<>2 then [calendar Date])=today-1,"YES","NO")


Can you please help me on this.

 

[Jon von der Heyden]

Welcome to the board.

Perhaps:

=If([calendar Date]=WORKDAY(TODAY(),-1),"Yes","No")