#1
|
|||
|
|||
Calculate the first day of next month
Hello, thank you all for providing this valuable forum.
I am trying to calculate the first day of next month based on the insert date and time field. I reviewed the tutorial and the section that I thought would contain the answer does not appear to work for my purpose. the result after updating the field is as follows and today's date is March 11,2021. Calculate the day & date of the nth day of next month Monday, 4 January 2021 (the result after updating the field) This is the instruction from the tutorial: Note: Increasing the ‘day’ variable returns the nth day of this month (eg day = 1 gives the 1st of the month, whilst day = 2 gives the 2nd of the month, and so on). The field includes code to ensure that the calculated date does not exceed the last day of next month. Any help is appreciated. Thanks Last edited by Charles Kenyon; 03-11-2021 at 07:43 PM. Reason: added link to tutorial |
#2
|
||||
|
||||
I suggest you read the tutorial's Introductory Notes, especially the part about Internationalization Issues...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculate amount of days per month from a given timerange | Yde1203 | Excel | 3 | 05-02-2019 08:13 PM |
Average for the month | joflow21 | Excel | 4 | 10-21-2013 06:57 AM |
How to show just day and month | ketanco | Project | 2 | 06-14-2012 03:25 PM |
Re: a month-old post with no replies. | BudVitoff | Outlook | 0 | 10-10-2011 10:22 PM |
Day and Month to Uppercase | Andy2011 | Word VBA | 1 | 07-22-2011 04:34 PM |