Oct 04 2021 02:48 AM
Hello
How do i get the numbers of days between 2 dates?
Example:
17-06-2021 - 19-06-2021 i want to count the days between the 2 dates(numbers of days 2). And if possible to always use the date of the day
Best Regards
Henrik
Oct 04 2021 02:51 AM
Oct 04 2021 02:55 AM
Oct 04 2021 03:02 AM
Days in Excel are sequential integers numbers starting from 1 which is Jan 01, 1900 (on Windows). Format only defines how to show such numbers. If you enter =TODAY() and apply General format that will be
Oct 04 2021 03:10 AM
SolutionPlease check in attached file
Oct 04 2021 03:10 AM
Solution