Forum Discussion
Solved
Beginning of Month formula on ID
Hello Experts,
I am looking for a formula that will return the beginning of the month for the first record of each LCID and all records after that first cell then return the beginning of the month for the next month. For the next ID, repeat
Please see attached example.
thank you very much
Tony2021 Perhaps I got it right this time. I give up. Two dates don't seem to agree with yours, though.
10 Replies
Tony2021 See attached. Formulae in the green shaded area.
- Hi Riny, ingenious. I have a follow up though.
If the following date value is in the same month then I would need to use the next month (This example is not in the sample file I posted...only in my production file).
Example: date1 = 1/1/22 and date 2 = 1/31/22.
I would need the output to be 1/1/22 and 2/1/22
Essentially the months should be successive and on the 1st of every month
I actually do not need the test for blanks since in my production file there will not be a case of any blanks.
thank you very much!Tony2021 Better to upload a file that resembles your real situation and indicate how the end result should look like.
