Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 10-24-2018, 02:08 AM
DanOnline DanOnline is offline Adding 9 months to month end date. Windows 10 Adding 9 months to month end date. Office 2016
Novice
Adding 9 months to month end date.
 
Join Date: Oct 2018
Posts: 7
DanOnline is on a distinguished road
Default

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?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding 9 months to month end date. Find Date Month charlesdh Excel Programming 11 07-24-2018 06:11 PM
Adding 9 months to month end date. Adding Months TimmiAndrew Excel 2 09-16-2015 10:21 AM
Adding 9 months to month end date. Is it possible to format today's date minus 12 months sarabeck Word 1 07-09-2015 04:53 PM
Adding 9 months to month end date. Counting Number of Months from a static date bremen22 Excel 4 11-25-2013 11:57 AM
Adding 9 months to month end date. Adding months to a Date tsindos Word 4 10-04-2011 11:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft