date, forumal to get the 02nd day of each month when is at the current month... e.g 11/02/22

[CJKPowerBI]

hello,

i was wondering if anyone knows a formula to always get the 02nd day of the current month...

that would be 11/02/22 and when deember comes then it would change to 12/02/22

thank you

[AllisonKennedy · Accepted solution]

2nd of Month = EOMONTH( TODAY(), -1) + 2

[AllisonKennedy · Accepted solution]

2nd of Month = EOMONTH( TODAY(), -1) + 2

[CJKPowerBI]

thank you @AllisonKennedy  that worked but i was wonderning and i should have said it before if:

- if today is more than the 10th of this month then to bring the 02nd of the next month otherwise the 02nd of this month...

let me know pls.

[Mikelytics · Accepted solution]

@CJKPowerBI 

2nd of Month adjusted = 
IF(
    DAY(TODAY())>10,
    EOMONTH(TODAY(),0)+2,
    EOMONTH(TODAY(),-1)+2
)

Kudos @AllisonKennedy : I dod not know the EOMONTH() function. Thank you!

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

[CJKPowerBI]

thank you @Mikelytics  and thank you @AllisonKennedy ... both worked great