I am using the below formula to calculate a date in the future, the only problem is, if there is no date in Cell G Colum I shows 00/01/1900, how do I get rid of this?
Shazz=DATE(YEAR(G2)+H2,MONTH(G2),DAY(G2))
xx
I am using the below formula to calculate a date in the future, the only problem is, if there is no date in Cell G Colum I shows 00/01/1900, how do I get rid of this?
Shazz=DATE(YEAR(G2)+H2,MONTH(G2),DAY(G2))
xx
Try:
=IF(G2="","",DATE(YEAR(G2)+H2,MONTH(G2),DAY(G2)))
EDIT: Alternative to what you are using: =IF(G2="","",EDATE(G2,H2*12))
Last edited by Cutter; 04-05-2012 at 07:05 AM.
this will help
=if(G2<>"",DATE(YEAR(G2)+H2,MONTH(G2),DAY(G2)),"")
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks