Hello.
I am trying to recreate a broken Excel spreadsheet for Numbers where I only have to fill out a cell with the correct word for the month and a cell with the year and then one row automatically adjusts itself with using the proper day name abbreviations and another row with the correct date without year.
Example (sorry, cannot find the table function to present it a bit clearer):
Month: February
Year: 2017
Row 1:
Wed
Thu
Fri
Sat
Sun
Mon
Tue
...
Row 2 (yes, in non-American formatting):
01.02.
02.02.
03.02.
04.02.
05.02.
06.02.
07.02.
...
Is that possible with formulas and functions and if so, then how?
Thanks for any pointers.
PS: I found the cell formula for the DATE in Excel: =DATE($E$4;MONTH("1."&$D$4);1)
Cell E4 contains the year, D4 contains the month in text form.
And this is the WEEKDAY cell formula: =IF(B14="";"";WEEKDAY(B14))
B14 is the cell with the DATE formula above.
I guess I have to find the equivalents in Numbers.
I am trying to recreate a broken Excel spreadsheet for Numbers where I only have to fill out a cell with the correct word for the month and a cell with the year and then one row automatically adjusts itself with using the proper day name abbreviations and another row with the correct date without year.
Example (sorry, cannot find the table function to present it a bit clearer):
Month: February
Year: 2017
Row 1:
Wed
Thu
Fri
Sat
Sun
Mon
Tue
...
Row 2 (yes, in non-American formatting):
01.02.
02.02.
03.02.
04.02.
05.02.
06.02.
07.02.
...
Is that possible with formulas and functions and if so, then how?
Thanks for any pointers.
PS: I found the cell formula for the DATE in Excel: =DATE($E$4;MONTH("1."&$D$4);1)
Cell E4 contains the year, D4 contains the month in text form.
And this is the WEEKDAY cell formula: =IF(B14="";"";WEEKDAY(B14))
B14 is the cell with the DATE formula above.
I guess I have to find the equivalents in Numbers.
Last edited: