Using multiple if statements

T

teddyt72

Joined
Jan 6, 2010
Messages
1
Reaction score
0
Hi there,

I'm trying to create a formula for a calendar/ schedule.

I have a set of dates running along the top, and then a list of events along the left with 2 dates, start and finish. These feed in from another sheet and I want the calendar to auto populate with these dates.

Event > Date1 > Date2
Event > Date1 > Date2

So I've got an IF statement to say: If the date on the top = Date1 then return "S". But I then want to add if it = date2 then "F". Can I do that?

=IF($B7=D$5,"S","")

Date1 = B7
Today's date= D5

Thanks in advance.

Eddie.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I have a listbox in a form update a query 2
Multiple columns sort 4
Work tracking query 2
Previous and Current Record Date Calculation 3
countif using multiple if statements 4
SQL, XML, Nested Datagrids and the like 1
Access Date Question 1
Can I have a cell change to red/green if not equal to: 7

Top