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
The screenshot is hard to read. You should be able to attach a workbook to a Private Message to me (click on my user picture)
I tried to start a new discussion and it kept saying error and to try again 😥 I also couldn't see an attachment icon, but can now 😃.. but it doesn't seem to be working for me ! Will try again... ...