I have a custom date field in an SO which I need to populate from custom week number and day number fields. I assume I also need a custom field to auto-populate to the current year for this to happen? Day 1 will always be a Monday. I really do not know how to make a formula out of this. for example:
If the following are populated with
custom week number field = 4
custom day number field = 3
Result for the custom date field should be: 1/24/2024 Also, can I make the custom date field flexible (dependent on the date format in the general preferences of the account)?