Hey all,
New user of Excel.I need help making a formula that would show expiration dates. I just need to put a date in one column and have it spit out an expiration date 1 year later in the next column. Would be greatly appreciated if someone could help me out.
Last edited by VBA Noob; 10-29-2008 at 02:31 AM.
Assume the intial date is in E8, then the formula is =DATE(YEAR(E8)+1,MONTH(E8),DAY(E8)).
Will automatically adjust for leap years.
Last edited by Kieran; 10-28-2008 at 11:10 PM. Reason: Cant type
Kieran
Or =EDATE(A1, 12) if the Analysis ToolPak add-in is loaded.
Entia non sunt multiplicanda sine necessitate
if i put the formula in on the formula bar for h2 and I 2 its not working correctly.Originally Posted by Kieran
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks