Forum Discussion
Excel formula to populate a cell with Yes/No depending on dates on other cells.
In E4:
=IF(AND(INDEX(C4:C1000,COUNT(B4:B1000))<>"",INDEX(D4:D1000,COUNT(B4:B1000))=""),"Yes","No")
If you expect to fill below row 1000, adjust the formula accordingly.
Hello
I have attempted as formula for this, but I'm getting something wrong somewhere and I'd very much appreciate any assistance.
I basically want to write a formula, (or know if it is possible!) that populates a cell with an amount in a column, depending on the date in a cell
So, say, IF L11 is less than 10/01/2025, then equals S10, if not equals 0
But it would also be useful to have one to complete the task of if falls between two dates, then populate cell with amount.
The spreadsheet I am creating is for supplier payments due, for the current week and the following week or after this.
I think I will be able to write my own formula to pull out any direct debit designated ones, once I have seen the solution to this one, hopefully!
That is a very different problem, it would have been better to start a new discussion.
Please provide more detailed information. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
I can only post a screenshot. The paperclip does nothing on my pc
CAN ANYONE TELL ME HOW I CAN GET A YES OR NO ANSWER ON WHETHER A DATE IS GREATER THAN 28 DAYS OR LESS THAN 28 DAYS I.E. BASED ON THE DATES IN ONE COLUMN ANOTHER COLUMN WOULD HAVE A FORMULA TO DISPLAY YES OR NO DEPENDING IF THAT DATE WAS 28 DAYS AGO OR LESS. HOPE THIS MAKES SENSE
Let's say you have dates in D2 and down.
In E2:
=IF(D2<=TODAY()-28, "Yes", "No")
Fill down.
(Please turn off Caps Lock. Using ALL CAPS is the internet equivalent of shouting loudly)
