Hi to all.
The formula in B6 increases the date of 2 months to every new year in B2
It is possible to increase not every January 1 but the day / month of the date in B2?
I attach example.
max_max
Hi to all.
The formula in B6 increases the date of 2 months to every new year in B2
It is possible to increase not every January 1 but the day / month of the date in B2?
I attach example.
max_max
In B4 copied down every two rows
=DATE(YEAR($B$2),MONTH($B$2)+ROWS($B$2:$B4), DAY($B$2))
Note: If the month in question has less days than the month in B2, the result will end up in the next month. For example, 7/31 to February will be 3/3/2018 as there are only 28 days in Feb.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi chemistB,
That's no good.
You can not add rows or edit cells in the post example.
You can only modify the formula in cell B6 in other cells there are other formulas.
max_max
So you want the date in B6 to have the same "Day" as in B2?
Yes
The formula in B6 must increase by 2 months the same day / month that is in B2
Hi,
Has anyone understood how to solve the formula?
max_max
Hello
I modified the formula:
=SE(MESE(B2)=MESE(B4);SE(B4>0;SE(VAL.ERRORE(INT((ANNO(B2)-ANNO(B4))/6)&" "&"anno/i -"&" "&RESTO((ANNO(B2)-ANNO(B4));6)*2&" "&"mese/i");"";INT((ANNO(B2)-ANNO(B4))/6)&" "&"anno/i -"&" "&RESTO((ANNO(B2)-ANNO(B4));6)*2&" "&"mese/i");""))
=IF(MONTH(B2)=MONTH(B4),IF(B4>0,IF(ISERROR(INT((YEAR(B2)-YEAR(B4))/6)&" "&"anno/i -"&" "&MOD((YEAR(B2)-YEAR(B4)),6)*2&" "&"mese/i"),"",INT((YEAR(B2)-YEAR(B4))/6)&" "&"anno/i -"&" "&MOD((YEAR(B2)-YEAR(B4)),6)*2&" "&"mese/i"),""))
Works in part, ie the years / months are displayed only when the months of dates in B4 / B6 are the same.
They should always look like the previous formula:
=SE(B4>0;SE(VAL.ERRORE(INT((ANNO(B2)-ANNO(B4))/6)&" "&"anno/i -"&" "&RESTO((ANNO(B2)-ANNO(B4));6)*2&" "&"mese/i" );"";INT((ANNO(B2)-ANNO(B4))/6)&" "&"anno/i -"&" "&RESTO((ANNO(B2)-ANNO(B4));6)*2&" "&"mese/i" );"")
=IF(B4>0,IF(ISERROR(INT((YEAR(B2)-YEAR(B4))/6)&" "&"anno/i -"&" "&MOD((YEAR(B2)-YEAR(B4)),6)*2&" "&"mese/i" ),"",INT((YEAR(B2)-YEAR(B4))/6)&" "&"anno/i -"&" "&MOD((YEAR(B2)-YEAR(B4)),6)*2&" "&"mese/i" ),"")
an help?
I attach example.
The new formula in C6
max_max
Last edited by max_max; 08-01-2017 at 02:04 PM.
Hello
Maybe I did not explain it?
max_max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks