User Profile
Life_is
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Help Needed: Hide/Unhide rows of Terminated/rehired employees based on date cell value
Hi All, hoping for some help. Our business has high and low employment demand depending on the number and size of projects, as a result we terminate and rehire many of the same employees over time. Additionally, we offer 3 different types of PTO tracked in 3 separate workbooks, so adding, removing and re-adding the same employees gets time consuming. I would like to hide a row based on a date being entered in the termination date column D and unhide the row when the employee is rehired. If possible, to unhide terminated employee enter their name in C1; to temporarily unhide row then clear the termination date and enter the rehire date in Column E to keep row unhidden; if they are terminated/rehired at a later date the same action repeats, except then the rehire date would, be cleared the next time the same employee is terminated. I would, also, note that the row range will grow over time. I have tried Advanced Filters, but this action to hide then unhide rows is not efficient and leaves room for too many errors where multiple users are involved. I'm not well versed in VBA, but see that it is, likely, my only option; it will be the only VBA in the workbook. If what I'm asking is not a viable option, what would be the best solution? Any help is greatly appreciated. Thank you, Shawn634Views0likes2CommentsHighlight an anniversary date for the whole calendar year
Below is a section of the workbook that has earned bonus vacation hours based on anniversary date that I will be sharing with a group of people that need to see current available bonus hours for each persons calendar year based on the date they were hired. In this example, I need A6 thru E6 to stay highlighted 11/12/2022 thru 11/11/2023 and A7 thru E7 to stay highlighted 11/12/2023 thru 11/11/2024 when those dates roll around, next year it will roll over to 2023 and 2024 and so on. All the formulas I've found are based on today's date not from YEAR / MONTH / DAY to YEAR / MONTH / DAY I know there is a simple formula and I'm over thinking it. Thanks so much for any help offered. A B C D E NAME HIRE DATE ANN DATE YEAR AVAIL BONUS HRS DOE, JOHN 11/18/2018 11/18/2022 2022 40 DOE, JOHN 11/18/2018 11/18/2023 2023 0 DOE, JANE 4/5/2016 4/5/2022 2022 0 DOE, JANE 4/5/2016 4/5/2023 2023 0454Views0likes0CommentsRe: Highlighting an anniversary date for 30 days
MindreVetande Thank you so much for your response For example, I have an employee's hire date as 12/1/2018 in B5 I need another cell to stay highlighted for 30 days "after" the current date of 12/1/2020 is reached. This formulas works to highlight the cell, but for only the one day of the anniversary .. somewhere in this formula I should be able to add +30 days, I've tried several options, I just can't seem to make it work. =(MONTH(TODAY())=MONTH(B5))*(DAY(TODAY())=DAY(B5))2.9KViews0likes0CommentsHighlighting an anniversary date for 30 days
I have applied this conditional formatting =(MONTH(TODAY())=MONTH(B5))*(DAY(TODAY())=DAY(B5)) and it works like a charm!! However, I cannot seem to figure out how to add in the formula for the cell(s) to stay highlighted for 30 days. I added +(DAY(30)), but it highlighted everything with a date. Any help is greatly appreciated. ShawnSolved3.1KViews0likes5Comments
Recent Blog Articles
No content to show