You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hi! For my personal use, I have to write a perpetual vertical calendar to calculate monthly working hours with numbers.
I used the CONCATENATE function to connect the data (month/year) of the drop-down menu, but it works only for january of all the years, not for other months, so this isn't the right way.
Do you have any ideas to help me?
MacBook Air (M2)
You can try something like this:
Formula in A3 of the virtual perpetual calculator:
=Mese e anno::A4
Formula in A4, filled down:
A3+1
Formula in B3, filled down:
=NOME.GIORNO(GIORNO.SETTIMANA(A3;1))& " " & GIORNO($A3)
The other tables do the same thing, with a slightly different look. One leaves days in the following month gray, another tries to show just blanks.
The document is here (Dropbox download).
As with the Calendar template, hide the extra rows and columns in the Month and Year table when it's all working to satisfaction.
To see the formulas in English just go to File > Advanced > Language & Region ...
SG
You can try something like this:
Formula in A3 of the virtual perpetual calculator:
=Mese e anno::A4
Formula in A4, filled down:
A3+1
Formula in B3, filled down:
=NOME.GIORNO(GIORNO.SETTIMANA(A3;1))& " " & GIORNO($A3)
The other tables do the same thing, with a slightly different look. One leaves days in the following month gray, another tries to show just blanks.
The document is here (Dropbox download).
As with the Calendar template, hide the extra rows and columns in the Month and Year table when it's all working to satisfaction.
To see the formulas in English just go to File > Advanced > Language & Region ...
SG
Thanks for reply!
It works like my solution, it's ok for january, if you slide other month, the day number is wrong.
Also, if the number of days in the month isn't 31 (like February), it doens't stop ad the right day.
to create a date/time you can use the function DATE().
I suggest you enter the month number (rather than the name). Assuming you do this, you may follow the steps below.
Also... I live in the US where the decimal separator is the period ('.') and the thousand separator is the comma (','). I notice you are in Europe and the formulas you posted use the semicolon as the argument separator. replace the commas you see in my formulas with the semicolon.
the function DATE() takes threes arguments as follows:
DATE(YYYY, MM, DD)
you'll need to replace DATE with the word in Italian (I think)
for cell B3 you can use this formula as follows:
=DATE("Mese e anno"::$A$2, "Mese e anno"::$A$1, A3)
shorthand for this is:
B3=DATE("Mese e anno"::$A$2, "Mese e anno"::$A$1, A3)
select cel C3, copy select cells C3 thru the end of the column, paste
you can try this formula to limit the listed days to only this in the current month:
=IF(DATE('Mese e anno'::$A$1, 'Mese e anno'::$B$1, A2)≤EOMONTH(DATE('Mese e anno'::$A$1, 'Mese e anno'::$B$1, 1),0), DATE('Mese e anno'::$A$1, 'Mese e anno'::$B$1, A2), "")
Perpetual vertical calendar
