![]() |
#4
|
|||
|
|||
![]()
Hi,
I have tried using the field given under "Calculate the day & date of the last or nth-to-last day of a given month" With the ‘DATE’ expressions in the original fields to my date field. And the options set to subtract 0 offset 9. The result is the month 9 months in advance but the date is not always the last date of the month. I.e. 31 Jan 18 generates 30 Oct 18. 28/2/18 generates 30/11/18. 31/3/18 to 30/12/18 and so on. Is there a way around this? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
charlesdh | Excel Programming | 11 | 07-24-2018 06:11 PM |
![]() |
TimmiAndrew | Excel | 2 | 09-16-2015 10:21 AM |
![]() |
sarabeck | Word | 1 | 07-09-2015 04:53 PM |
![]() |
bremen22 | Excel | 4 | 11-25-2013 11:57 AM |
![]() |
tsindos | Word | 4 | 10-04-2011 11:20 PM |