|
|
|
|
#1
11-21-2021, 04:05 AM
|
||||
|
||||
Your formula 19/11/2021 - 18/10/2021 =TEXT(A3-A2,"dd") is correct but it returns the day on which day 32 starting 01/01/1900.
Using a text function to return dates might get you in trouble for later analysis. much easier to use A3-A2 and format as suggested. The underlying value will not change and stay a number 
|
|
|
|
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 7 64bit 
Office 2010
Hybrid Mode