Calendar in excel for shelf life analyses

Hello,
In Excel i am needing a formula that can tell me on whatever day we are in, which samples to go get and analyse.
For example:  i make a product, the analyses to made to it are 3 in 3 months until it reaches a year. So Product X was made on the 2/1/2018 - analyses to be done on 2/4/18 - 2/7/18 - 2/10/18 - 2/1/19
I need a calendar that can automatically tell me on 2/04/2018 i need to do analyses to product X and so on.
Anyone can help me
Diana PinhaoNPD ManagerAsked:
Who is Participating?
 
ShumsConnect With a Mentor Distinguished Expert - 2017Commented:
Hi Diana,

Welcome to Expert Exchange!

Please find attached...

Hope this is what you are looking for :)
ProjectCalendar.xlsx
0
 
Máté FarkasDatabase Developer and AdministratorCommented:
Do you really need a calendar or only a function / formula which tells you next 4 x 3 months interval?
0
 
Diana PinhaoNPD ManagerAuthor Commented:
i would need a calender where i look up todays date and know if i have any analyses to be done. as it will be a continuasly fed document with actual projects that are happening at the moment, so i will have at least 1 project per week that i will be adding to my table and therefor need it to replicate it to a calendar. do i make sense?
shelf-life.xlsx
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Roy CoxGroup Finance ManagerCommented:
I would simply use Conditional Formatting to highlight samples that need to be done today. You can add or amend formats to display say tests for say + 7 days from today
shelf-life.xlsx
0
 
Diana PinhaoNPD ManagerAuthor Commented:
Thank you very much for your help, that is very useful... i couldn't get around all these formulas to work properly.
0
 
ShumsDistinguished Expert - 2017Commented:
Hi Diana,

Those formulas are for calendar, the one you need has 5 named range formula for DateStarted, Months3, Months6, Months9 & Months12 which I am using in Conditional formatting.

Are you trying to implement these formulas in your original workbook? If yes, then I would advice copy your projection sheet to calendar workbook and change those named range.

If you need further help, please post your working workbook.
0
 
Roy CoxGroup Finance ManagerCommented:
The Calendar doesn't list the jobs to do for certain dates conditional formatting when applied highlights all jobs schedules for today

It is possible to have a calendar that lists tests per day, but it is not simple.
0
 
Diana PinhaoNPD ManagerAuthor Commented:
Thank you very much this has helped alot.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.