Thread: Using the If function for a date range
View Single Post
  #1   Report Post  
Jon Keym Jon Keym is offline
Junior Member
  
Posts: 2
Default
Quote:
Originally Posted by Kevin@Radstock View Post
Hi Jon Keym

If the date in A1 is a proper date & not text. Then the following formula in B1 should suit your requirement.

=YEAR(A1)
Works perfectly. Thanks very much.
Reply With QuoteReply With Quote