Forum Discussion
Problem with date
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 ,,,,
Hi Sergie ,, I have the value of 3 as a month number and 2021 as a year ,, I would like to get a 3/3/2021,, Can you help me ??
Like
A B C
Year Month Date
2 2021 3 3/3/2021
How do i get the date from only month and year like above ??
Like
A B C
Year Month Date
2 2021 3 3/3/2021
How do i get the date from only month and year like above ??
Latest question is in separate thread here Date - Microsoft Tech Community
That's the same DATE() function. If third day of the month is hardcoded, when
=DATE( A2, B2, 3)
