Hi,
Is there any formula to automatically show the full month range when I key in a date in that particular month?
For example, in column A1, I type in 6/10/2021, and then in column A3 it will show 1 - 31 October 2021.
Thanks!
Is there any formula to automatically show the full month range when I key in a date in that particular month?
For example, in column A1, I type in 6/10/2021, and then in column A3 it will show 1 - 31 October 2021.
Thanks!