Sharepoint Excel Question re dates

Question

Hi,

I cannot for the life of me figure out from google how to do this! In using Sharepoint excel if that makes a difference.

I have one cell with a date in, for example 16/11/2020 (this is manually entered) and I'd like another cell, the one next to it to have the days between that date and today. So if today was 17/11/2020 it would say 1, or if today was 01/12/2020 it would then say 15.

Any help would be greatly appreciated!

Answer 1

Hi @Steph Derbyshire

Assuming the date you enter is in A2 and you want the result in B2. In B2 enter formula: =TODAY()-A2

Any question please let me now. And if this solves your problem please mark this reply as answer to help others with a similar request. Thanks in avance & Nice day...

Answer 2

Hello @Steph Derbyshire ,

Please follow steps:

1.Create an Excel in SharePoint Online Document Library
2.On the Excel workbook, create two columns.

• Set the first column cell to Date format
• In second column cell, define the function formula: =(DAYS360(A2:A4,TODAY())&"")

3.After performing the operation, you will see that Excel will automatically calculate days between current Date

Thanks,
Echo Du

===============

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.