|
|
#1
03-06-2017, 11:52 AM
|
|||
|
|||
Formula Head Stracher
Problem: Budget is $100K for 14 months, $7142.85 per month
=DATEDIF(Start date,enddate, "m") start date is 1/1/2017 enddate is 5/1/2017, results = 4 month, $7142.85 * 4 = $28,571.42 Now same start date and end date =DATEDIF(Start date,enddate, "d") results = 121 days, $235.29 per day * 121 days = $28,470.58. Different of $102. Where is my error? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Running head with page number
|
ClaireB | Word | 22 | 03-09-2017 11:48 AM |
| Leterhead doing my head in.... | albertc30 | Word | 1 | 11-19-2015 05:55 PM |
|
Run-In Head (FrameMaker feature) available in Word?
|
Luxanais | Word | 1 | 06-10-2015 01:42 PM |
|
New graphics in head is obscured
|
jrasicmark | Word | 3 | 05-31-2014 04:44 PM |
|
Change Running head for each sections
|
ClaireB | Word | 6 | 10-25-2013 08:40 PM |
Windows 8 
Office 2016
Threaded Mode