#1 ·
I’ve put together a school year calendar in Excel, and I need a specific date in a given month to display as the letter "P" (for holiday), while keeping all other dates exactly as they are. For instance, if October 8th is a holiday, I want it to show up as "P" when entered, but leave everything else untouched.
I'm trying to use an IF function, but how do I structure the formula so that if the condition isn't met, it doesn't change anything?
I'm trying to use an IF function, but how do I structure the formula so that if the condition isn't met, it doesn't change anything?