Hi
Is there a formual like if, that can look at a specific cell and if there is certain text within the text in that cell, you can tell it to calculate based on that?
I.E. in cell a1 it says "Monday 3rd" then in cell c1 i want to look at cell a1 and if Monday is within the text then i can tell it to calculate based on that?
Bookmarks