Hello,
In the factory where I work, we use the "Julian Day" calendar to list our batches.
By Excel I got the formula below that when I write the date 12/01/2023 (were we use day, month and year) it returns me the year and the letter "V" (that is necessary for our process) and the referent date of the "Julian Day" calendar
Formula:=TEXT(B3;"aa")& TEXT(B3; "V")&TEXT(B3- DATE( YEAR(B3);1;0); "000")
Thus, 12/01/2023 = 23V043
But I would need to apply this formula inside the userform, according to the attached file.
Can someone help me?
TEST.xlsm
convert-date-to-julian.xlsx
Bookmarks