LinkBack URL
About LinkBacks
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks