In a library my calculated column calculates what date Monday is the week after a document is last Modified.


I also want to add the minutes and seconds (not the hours):

=Modified-WEEKDAY(Modified,2)+8&" "&TEXT(Modified,"mm:ss")

Unfortunately, I can't get it to work. I get '42856.4667361111 12:06' instead of the date and time (minus the hours). What am I doing wrong?!

1 Answer 1


Try this. You will need to convert the first part to date format:

=TEXT(Modified-WEEKDAY(Modified,2)+8,"dd/mm/yy")&" "&TEXT(Modified,"mm:ss")

More information here


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.