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.
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.
Tony2021 Perhaps I got it right this time. I give up. Two dates don't seem to agree with yours, though.
- 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!