Answer the question
In order to leave comments, you need to log in
How to determine the date today without a year?
Hello everyone, help with the excel formula, there are birthday people, they have a year of birth, I'm trying to highlight the cell with birthday people in a different color, I run into the fact that today = TODAY () Returns the current date with a year. Now I tried it like this:
=$D2=DAY(TODAY())=MONTH(TODAY())
didn't work(
How to use these formulas correctly?
Answer the question
In order to leave comments, you need to log in
It is necessary to compare both the month and the day, and not the day with the month.
Something like this:
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question