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.
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.