Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...
When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

simple date and cell formating help

Thread starter bfraser
Start date Jan 29, 2010

B

bfraser

Member

Jan 29, 2010

#1

NEVER MIND W/A LITTLE PERSISTENCE AND PATIENCE I FIGURED IT OUT. ALL OUT OF PATIENCED

Hui

Excel Ninja

Staff member

Jan 29, 2010

#2

+if(A2=0,"",A2)

Hui

Excel Ninja

Staff member

Jan 29, 2010

#3

Whoops

Put this in B2

+if(A2=0,"",+A2+365)

You must log in or register to reply here.

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top