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!!!