Re: [libreoffice-users] Date number has 5 digits

Peter,

Not sure what you are trying to accomplish.

1- The date in January.$A5 is 12/27/2021. You can see that by formatting cell January.$A5 as date. 

2- The date is internally represented as number 44557. You can see this by formatting January.$A5 
as number.

3- To get the day of the month use formula =DAY(January.$A5)

4- Your formula generates a error because you try to do arithmetic with a string (“Monday “). Use 
‘&' i.s.o. ‘+’ to append.
        The formula then becomes:

="Monday      “&DAY($January.$A5)

To het the weekday of the specified day use the next formula:

=TEXT(WEEKDAY($January.A5);"NNN")&"           "&DAY($January.A5)

Success,
Rob.




> Op 29 dec. 2020, om 15:27 heeft Peter Dutton <Look@iPadRing.net> het volgende geschreven:
>
>
>
> In cell
>          A4 is the following code;
>
>
> ="Monday      
>          "+January.$A5
>
>
> January.$A5 
>          has the number 27 in it (December 27)
>
>
> What
>          appears in cell A4 as a result is- Monday    44557
>
>
> What is
>          needed is- Monday    27
>
>
> I've
>          tried reformatting cell A4 to a date or text or a number to no
>          success.
>
>
>
>
> Any
>          idea how to fix this?
>
>
>
>
> Thanks,
>
>
> Peter
>
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy