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


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, privacy policy and cookie policy

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