I saw Barry Houdini's formula to calculate the 4th Friday in January of any year (A5 "=A4-DAY(A4)+29-WEEKDAY(A4-DAY(A4)+2)" (my date was in A4), but when I applied his second formula ("=A5+28+(DAY(A5+28)<22)*7") to record the 4th Friday of the following months by pasting into A6, I received only the numeric value of the date.
What do I need to do to show the actual date 25th February,25th March etc?
What do I need to do to show the actual date 25th February,25th March etc?