₦airaland Forum

I am struggling mightily on a spreadsheet , please i'd appreciate all of your help. So here's what i need.

1. I need a range of cells (say B) to show dates, specifically every Monday, Tuesday, Thursday and Friday of the month (next 2 months in fact).
2. If B2 is, say a Monday, then cell C2 should show the time 12:00pm. The idea is to have all cells under C give the value of 12:00pm for Mondays, Tuesdays, and Thursdays, while 02:00pm for Fridays of the month.

Excel and Programming gurus should please come to my rescue. Please help me with a formulas that can solve this

Will cell B2 ever hold values other than Monday, Tuesday, Thursday or Friday?

If No then in C2, type

=IF(B2<>"Thursday", "12:00pm","2:00pm" )

(delete the space between the closing parenthesis and the ".)

airsaylongcon:
Will cell B2 ever hold values other than Monday, Tuesday, Thursday or Friday?

If No then in C2, type

=IF(B2<>"Thursday", "12:00pm","2:00pm" )

(delete the space between the closing parenthesis and the ".)

mehn, just seeing this. thanks a million for the reply. i sorted out number 1 on my list, thanks for sorting out number 2. now lemee try it