|
|
#6
11-20-2021, 09:35 AM
|
||||
|
||||
Quote:
He should be trying =A3-A2 for the number of days. If he'd used =TEXT(A3-A2,"dd/mm/yyyy") he'd have got 01/02/1900 he used =TEXT(A3-A2,"dd") so he only saw the red portion. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extracting date, month & year from a text string without using date format Help | Haha88 | Excel | 5 | 08-06-2021 01:19 PM |
| Use Original Award Date or Mod Award Date For Date-Based Recurring Tasks | KBCasey27 | Project | 1 | 04-30-2021 12:22 AM |
| Change font color if date in column F is prior to today's date. | kevinbradley57 | Excel Programming | 1 | 12-05-2018 07:35 PM |
| Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Windows 10 
Office 2019
Threaded Mode