#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
See the attached.
Edit: There shouldn't have been any text in F20. Last edited by xor; 03-07-2017 at 04:49 AM. |
#3
|
|||
|
|||
Thank you.
|
|
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 |