Display an ID number if a date in column is today.

[jbrooks1988]

Hello all

I have been trying different ways and cant get it right. I have a spreadsheet with a list of employees and a training date. I am trying to have a field at the top of the page (H2) to say "training today" if a date in several column ranges (J6:J36, L6:J36, O6:O36 etc...) matches today, and if not so say "No training today).

I have got as far as an If function saying "yes" if the adjacent cell is todays date, however this is not ideal for what's required.

I have multiple sheets for different departments in the same spreadsheet which I will carry across the formula.

I have conditional formatting which highlights if a date is today, but I have a front sheet with stats on which I will link a cell to each sheet's H2 field so at a glance i'll know if anyone has training without checking every sheet.

Thank you

[FrisoKoopman]

Hi JBrook1988,

Try this in H2 =IF(COUNTIF(E3:E5,TODAY())>1,"Training Today","No Training Today")

or, not sure if I understand the question correctly

Like This.png
=IFNA(INDEX($D$2:$F$2,1,MATCH(TODAY(),D3:F3,0))&" Today","No training")

you may want to rewrite the ranges to match you data.

[Richard Buttrey]

Hi,

It would be easier to comment if we could see the workbook but the approach I'd adopt is use an

Please Login or Register  to view this content.

formula above every column to identify whether today's date is in the column

Then assuming the formula is in say J1, L1 and O1, H2 becomes

Please Login or Register  to view this content.

[FlameRetired]

Agree with Richard.

It would be easier to comment if we could see the workbook ...

If you are not familiar with how to do that:

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

[jbrooks1988]

Thanks all, ive got it sorted now