Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie: Iasminica Profile
| Femeie 24 ani Arad cauta Barbat 24 - 52 ani |
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 739
|
|
You want to get the date interval of each month, using a date in a column or just the number of the month in the year.
A1:A12 = various dates, 1 from each month B1:B12 = numbers 1 to 12, corresponding to the months. C1:C12 = FIRST DAY OF THE MONTH D1:D12 = LAST DAY OF THE MONTH
C1 =DATE(YEAR(TODAY());B1;1)
If you work with the dates in column A instead of the numbers in B, you can use the following formula in C1 instead:
C1 =EOMONTH(A1;-1)+1
Now for the last day of the month you use the first day of the month:
D1 =EOMONTH(C1;0)
or the date in A1:
D1 =EOMONTH(A1;0)
Source:
|
|
pus acum 3 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 17 ani
Postari: 2186
|
|
If you want, for example, to just extract the number of the last day of the month, and not the date:
eg. for February to display just 28 instead of 28.02.2023
Assuming that in cell X2 I have the first day of the month, eg. 01.02.2023
=DAY(EOMONTH(X2;0))
will return just the number 28.
_______________________________________
|
|
pus acum 1 an |
|