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 mont...
Tony2021 Perhaps I got it right this time. I give up. Two dates don't seem to agree with yours, though.
Tony2021 Not really. You speak of the "first cell" and the "next". Which are these? Why not write in plain words why D1 should be 01/10/2021 and why should the D2 become 01/11/2021 etc. And most importantly, why should D5 be 01/01/2022? And D6 jumps back to 01/12/2021 again. I just don't see the logic. Sorry!
Hi Riny, sorry for the confusion.
maybe we are mixing the European and English formats? I hope that is not part of the problem.
D1 = Oct 1 and not sure if you mean 1/10/2021 = Jan 10 (but I assume its oct 1 but in d/m/y. I assume you are in Europe.
To answer your questions:
Frist cell = the first cell for that ID. (ie B2, B6, B9)
Next cell = the next cell for that ID. (ie B3, B7, B10)
D1 (I thk its D2 actually) is oct 1 since the value is oct 15 in B2 (need to return the beg of the month)
D2 (I thk its D3 actually) is Nov 1 since that is the next month after Oct 1. (need to return the beg of the month)
D5 is jan 1 2022 since D4 is Dec 1 2021 and the next month is jan 1, 2022.
I hope its more clear.
let me know... thank you and sorry for the confusion.
maybe we are mixing the European and English formats? I hope that is not part of the problem.
D1 = Oct 1 and not sure if you mean 1/10/2021 = Jan 10 (but I assume its oct 1 but in d/m/y. I assume you are in Europe.
To answer your questions:
Frist cell = the first cell for that ID. (ie B2, B6, B9)
Next cell = the next cell for that ID. (ie B3, B7, B10)
D1 (I thk its D2 actually) is oct 1 since the value is oct 15 in B2 (need to return the beg of the month)
D2 (I thk its D3 actually) is Nov 1 since that is the next month after Oct 1. (need to return the beg of the month)
D5 is jan 1 2022 since D4 is Dec 1 2021 and the next month is jan 1, 2022.
I hope its more clear.
let me know... thank you and sorry for the confusion.
- I now see I had a typo. You got it right. You could read my mind. Amazing. thank you and sorry for the confusion. It is perfect!
Tony2021 Perhaps I got it right this time. I give up. Two dates don't seem to agree with yours, though.