Hello:
I have the following days of the week in column A:
Tuesday
Wednesday
Friday
Saturday
Is there a formula I can use so that if it is Tuesday or Friday, then the number 5 is entered in the same row but in column B? Also, if it is Wednesday or Saturday the number 3 is entered in column B. If possible without VBA.
Thanks in advance.
I have the following days of the week in column A:
Tuesday
Wednesday
Friday
Saturday
Is there a formula I can use so that if it is Tuesday or Friday, then the number 5 is entered in the same row but in column B? Also, if it is Wednesday or Saturday the number 3 is entered in column B. If possible without VBA.
Thanks in advance.