K0st4din
Well-known Member
- Joined
- Feb 8, 2012
- Messages
- 501
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi all,
I'm trying to make it so that in cell A4 I have a year (2023, 2024, etc. the years are selected with a drop-down menu. In cell B4, a month is selected in the same way (1,2,3, etc.). I'm trying in cell D4 to display the first day of the specific month, i.e. if we are talking about October, display 1.10.2023, and in cell G4 display the last day of the specific month (in the example, it is 31.10.2023)
I found many options on the Internet, but there the dates are in one cell, and in my case, they are in different ones, and I can't do it. I would appreciate any help on how to put the formula together.
Thank you in advance!
I'm trying to make it so that in cell A4 I have a year (2023, 2024, etc. the years are selected with a drop-down menu. In cell B4, a month is selected in the same way (1,2,3, etc.). I'm trying in cell D4 to display the first day of the specific month, i.e. if we are talking about October, display 1.10.2023, and in cell G4 display the last day of the specific month (in the example, it is 31.10.2023)
I found many options on the Internet, but there the dates are in one cell, and in my case, they are in different ones, and I can't do it. I would appreciate any help on how to put the formula together.
Thank you in advance!
A4 | B4 | D4 | G4 | ||||||
2023 | 10 | 1.10.2023 | 31.10..2023 | ||||||