Mar 13 2021 04:20 AM
Mar 13 2021 04:54 AM
The date like 1/1/2021 could be received by
=DATE(C2,MONTH(A2&B2),A2)
Didn't catch how that's linked to monthly dates column.
Mar 14 2021 12:39 AM
Mar 14 2021 05:09 AM
@UserExcel , glad it helped
As a comment, usual practice now is to use EOMONTH instead of MonthKey in Date / Calendar table, not first of month. But that's up to you.
Mar 14 2021 05:44 AM - edited Mar 14 2021 05:49 AM
Thank you Serge, I have only month and year in my data so I need only date which was missing to use time intelligence ,, my boss is concerned with the monthly and quarterly visual report,, not in daily basis ,,,,
Mar 14 2021 06:01 AM
Mar 14 2021 06:28 AM
That's the same DATE() function. If third day of the month is hardcoded, when
=DATE( A2, B2, 3)
Mar 14 2021 06:32 AM
Latest question is in separate thread here Date - Microsoft Tech Community