specific date

I need to count all specific values in column B, only when column A contains a date within the last 90 days. Can anyone assist me with this?

Hello, I need to calculate the age of people 3 months and 1 year after a specific date (and the specific date varies just like DOB). So something like this: Age = age upto the specific date + 3 months and Age = age upto the specific date + 1 year Can someone help me with this if I have DOB...

I have multiple contracts that have been signed on a specific date. I need to know when the contract will auto renew. I would like to set up a spreadsheet that will tell me when the contracts are 30, 60 or 90 days from auto renewing from the date it was signed. All tutorials I have found show me...

Hello all, At the moment I have a rather clumsy way of calculating someone's age based on today. <tbody> B C D E F date of birth today year months answer <tbody> 06/05/2008 </tbody> =TODAY() =IF(MONTH(TODAY())>MONTH(B2),YEAR(TODAY())-YEAR(B2)...

I'm currently using... =SUMPRODUCT((Quantity)*(MONTH(Date)=7)*(Adjustment_Type="Booking In Error")) ... to calculate the sum of a column based on a specified date range (MONTH(Date)=7) and also based on a specific criteria (Adjustment_Type). Instead of finding the sum of the 'Quantity', can...

I want to find how to reference dates in months. For example, how can I create a formula in Cell E 43 and F 43, which will look up in the tables of debt drawdown "dates" and debt repayments "dates", and check if any of these happened to be in that particular "month", and if yes, the value...