|
|
#3
07-25-2019, 02:24 AM
|
|||
|
|||
Hi gmayor, thanks for replying, I already saw macropod document and exhaustively tested the proposed solutions with 'Set Delay, Set M, Set Y... fields' (Set delay to -7, expected 'Dec/2018', got 'jul/2019' or 'dec/2000') and others solutions in google search and nothing seems to work when date calculation involves year change.
|
|
|
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 |
Windows 10 
Office 2010 32bit
Threaded Mode