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
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
Máté Farkas
Do you really need a calendar or only a function / formula which tells you next 4 x 3 months interval?
ASKER
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
shelf-life.xlsx
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
shelf-life.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you very much for your help, that is very useful... i couldn't get around all these formulas to work properly.
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.
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.
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.
It is possible to have a calendar that lists tests per day, but it is not simple.
ASKER
Thank you very much this has helped alot.