![]() |
#5
|
|||
|
|||
![]()
Hey Paul,
Again, Thank you for all your help with Word. I really appreciate your patience with a old guy like me, who is just not getting it. So I went back and reviewed the Tutorial you created for Calculating a Date. Under the section called "Calculate a day, date, month and year, using n days delay" there is a date that does not make sense, 24-1-5054. I assume this is Jan. 24th 5054. If I toggle open the field there are 17 lines of code. How does this work? Do I use the "Insert" feature in Word, and if so, what exactly am I inserting? Do I just start using the cntl+f9 buttons to insert the bracers, and then start typing, and using that cntl+f9 to insert a new set of bracers, until all 17 are there? You had mentioned only 2 lines above, so again, I am lost as to what I am supposed to do. I'm also not seeing where I need to set 'n'? I just need the formula to calculate 3 business days from "today" and display that date. What am I missing (aside from common sense and a working brain) Thank you, Shawn |
Tags |
date calculations |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula to use a date to calculate an amount $. | melvin1942 | Excel | 13 | 05-22-2016 04:03 PM |
calculate date if date entered in cell, do nothing if blank | ConfuddledOne | Excel | 3 | 11-07-2014 09:37 AM |
Formula to calculate Date and Time | funkyfido | Excel | 2 | 06-25-2013 04:25 PM |
![]() |
ketanco | Project | 1 | 02-07-2013 06:50 AM |
![]() |
edwedw | Mail Merge | 3 | 11-30-2011 02:10 PM |