Forum Discussion

TMan5757's avatar
TMan5757
Copper Contributor
Jul 21, 2021
Solved

First and Last Day of the months formula

Hi everyone I need help with finding a formula that will take the 3 bottom months in chart one and have the formula put the first date of the month and the last day and put that into the correct peri...
  • Riny_van_Eekelen's avatar
    Jul 21, 2021

    TMan5757 Changed the formulae in columns A and B. Added what I think you want in column J, though I'm not sure that your Excel version supports it. Perhaps you need to enter the formula in A3 and confirm it with Ctrl-Shift-Enter and copy it down.

     

    File attached.