Offset Formula for Date returning 1/0/1900

[Luna_Maria]

Hi, I have an offset formula referenced to another sheet that contains dates, my problem is when my reference sheet is blank it is returning value of 1/0/1900 instead of blank. How should i make it appear as blank instead of having 1/0/1900?

=OFFSET(POAP!$I$5,$A2,$B2)

 

[maabadi]

Try this:

=IF(OFFSET(POAP!$I$5,$A2,$B2)="","",OFFSET(POAP!$I$5,$A2,$B2))

 

[Luna_Maria]

Try this:

=IF(OFFSET(POAP!$I$5,$A2,$B2)="","",OFFSET(POAP!$I$5,$A2,$B2))

Hi Thank you.! it is easy to incorporate it to other formula but it's my first time using offset so i had a hard time... this is a big help. appreciate it.

 

[maabadi]

You're Welcome & Thanks for Feedback.