|
|
#2
03-07-2022, 12:12 AM
|
|||
|
|||
What about adding a day to 'Last Day of Service' instead adding 1 to Datediff() days result? So e.g. instead of calculating Datediff's between January 1st and January 31th and adding 1 for days, you simply calculate all Datediff's between January 1st and February 1st!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| appt that occurs every year for 1hr per day for 10 days | scadaman29325 | Outlook | 2 | 07-13-2021 04:58 AM |
 Word field last month not working within year change
|
eduzs | Word VBA | 4 | 07-25-2019 04:31 PM |
| Calculate amount of days per month from a given timerange | Yde1203 | Excel | 3 | 05-02-2019 08:13 PM |
| Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
| How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
Windows 8 
Office 2016
Threaded Mode