Want to convert date to its Days Number format as is shown in Excel popup for formatting cell. I want to enumerate days between Arrival Date & Departure Date for further calculations. Screen Shot attached to clarify my query.
Solved! Go to Solution.
The idea proposed by @PowerAddict is correct. If you want to show exactly the same number as in your picture use this code.
DateDiff(Date(1900,1,0),Today(),Days)+1
The output will be a number
43876
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Dear Sir Hardit Bhatia,
Thanks for help.
KUDOS!!!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
71 | |
49 | |
41 | |
30 |
User | Count |
---|---|
266 | |
121 | |
95 | |
90 | |
81 |