![]() |
|
#1
|
|||
|
|||
|
Hi there! The goal is to list the last 12 months. I have this fields codes which are working fine within the current year: Code:
.
.
.
{QUOTE “01- { ={MOD({Date \@ MM} +10;12)-2 }” \@ MMM/yyyy}
{QUOTE “01- { ={MOD({Date \@ MM} +10;12)-1 }” \@ MMM/yyyy}
{QUOTE “01- { ={MOD({Date \@ MM} +10;12) }” \@ MMM/yyyy}
{QUOTE “01- { ={MOD({Date \@ MM} +10;12)+1 }” \@ MMM/yyyy}
Ps.: My region date format "DD-MM-YYYY", list separator ";". Any Ideas? Thanks in advance. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Empty date cell shows wrong month & year
|
Learner7 | Excel | 3 | 06-16-2019 11:09 AM |
can i make a dropdown style calender to select the month and year to enter vacation time taken
|
jamesbriese | Excel | 1 | 12-06-2016 01:00 PM |
| Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
| Macro now fails in Word 2013 after working for more than a year; still works in 2007 | cyraxote | Word VBA | 10 | 09-05-2015 12:33 AM |
| Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |