Example of the given date is 28.02.2017(from extracted data in Excel sheet)
What is the Excel coding to compute the number of days between a given date(fomat) against today date?
Thank you.
Example of the given date is 28.02.2017(from extracted data in Excel sheet)
What is the Excel coding to compute the number of days between a given date(fomat) against today date?
Thank you.
Welcome to the forum!
With your date in A1:
=ABS(TODAY()-A1)
This will work for dates that have passed and dates in the future.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
If the above do not work - then probably the "date" is not an excel date but just text which only looks as a date.
then try more complicated formula:
Formula:
Please Login or Register to view this content.
PS. if the output looks as date (say: Jan 18, 1900) set the format of the cell with te formula to General.
Best Regards,
Kaper
The formula is working good.
Thanks a lot!
You're welcome!.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks