Forum Discussion
TMan5757
Jul 21, 2021Copper Contributor
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...
- 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.
Riny_van_Eekelen
Jul 21, 2021Platinum Contributor
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.
- TMan5757Jul 21, 2021Copper ContributorThanks for the help it all seems to work