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 <[email protected]> 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: [email protected]
> 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: [email protected]
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
