CODEWITHSUNDEEP
libreoffice-calc
mestu
mestu

Reputation: 126

how to use DateValue function dynamically in libreOffice

Normally I can use DateValue function. But when I try to make it dynamic and select any cell for Datevalue function's argument it show error. May be I don't know actual format for using dynamic DateValue function. image

for example : I try to use DateValue in cell 3A according to B1(month) and B2(year) and day always 1

Upvotes: 1

Views: 626

Answers (1)

JohnSUN
JohnSUN

Reputation: 2539

Just use the DATE() function instead of the DATEVALUE() function

=DATE(B2;B1;1)

or for your format of month

=DATE(B2;FIND(B1;"   Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec ")/4;1)

Upvotes: 1

Related Questions