formatting cell by date

Hello Excel knowledge base I hope you can help me, (I did search previous threads but didnt seem to find an answer but it most likely is there) I have a table with a date in column D and I want to put a formula into the corresponding cell in column H that will show the number of months between...

Hi All I really need your help. I have an inventory in and out log. It logs date an asset was issued and date it was returned. I have everything in a drop down menu and i need the following. these assets are loaned out on a daily basis and returned on a daily basis. (Or supposed to be) there...

I am working on some conditional formatting based on a due date's relation to the current date. Here is what I'm trying to accomplish: 1. If the month of the due date (cell F4) is less than the month of the current date then highlight to red. This is what I used and it works fine...

I have 5-10 business days to complete a task. I need to be able to quickly see what's open or pending, and I need to be able to easily maintain it. I tried looking up formulas on my own, but after editing the ones I found I kept getting errors or only part of the row was formatted. I tried...

Hello!! I have built (with help) a spreadsheet that tracks different expiry dates, for training tickets, driver's licenses, course renewals etc... I would like to try and add a birthday alert, or conditional formatting to highlight birthdays, using the driver's license expiry date. But, because...