Hi All
Could you help me resolve a issue I have. I have a start date in c2 and a expired date in e2. When I add =c2+21 is shows me the correct date in e2 but when I take the date out of c2 I get 21/01/1900 in e2. Is their anyway around this show it done show this or is their another way of doing the formula.
Thanks
Rick
What is the criteria of returning a blank cell?
Date + 21 will add 21 days
Date - Another Date will return the difference, in days
So 29/9/2014 - 24/9/2014 = 5/1/1900, which is equivalent to 5
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
try
=if(c2="","",c2+21)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for your quick responses.
Martin you have cracked it and thanks very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks