example-

  1. Trevor3007

    sunday date

    hi, Is there a formula that if I put a date in a cell a1 , b1 will then return that weeks sunday date? Example:- a1 - 17/12/18 b1 = 23/12/18? many thanks in advance. Trevor3007
  2. M

    Simple or Complicated Sequencing Formula?

    Hi all, I need to know if theres a way you can make a formula for the parameters below- Plus 9 except when reaching a multiple of 10, then plus 10 then plus 19 then carry on with plus 9. For example- 12512, 12521, 12530, 12540, 12559, 12568, 12577. Many thanks if this can be done! Don't...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top