I
I
id_baton4eg2016-12-18 19:33:18
excel
id_baton4eg, 2016-12-18 19:33:18

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

2 answer(s)
J
John Smith, 2016-12-18
@ClearAirTurbulence

It is necessary to compare both the month and the day, and not the day with the month.
Something like this:
e060c51199334aec896fb8ab54036523.png

A
Alexander, 2016-12-18
@SmoKE_xD

Option 1: use =DAY() with formatting
Option 2: remove the last 5 characters from the end and get the day.month

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question