How to populate name if within date range

[kipdaballer31]

Hello all!!!

First time post, hopefully I can explain what I’m trying to do.

So I am trying to (on the dashboard) populate a persons name (I have 200+ names) if they need to be trained within 90/60/30 days from TODAYs date.

For example:

Name: Date last trained: Date need to be trained by:
John Doe Aug 24 2018 Aug 24 2019

I would need excel to populate John Doe name on the dashboard because he is within 60 days of needing to be trained.

Any help would be appreciated!

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!