So if you are using 730 what is the required output in leap years?
eg: If initial date is 1/1/2011 what is the required expiry date, 31-Dec-12 or 1-Jan-13? If the answer is 1-Jan-13 try with EDATE
=EDATE(IF(B2="",A2,B2),24)
So if you are using 730 what is the required output in leap years?
eg: If initial date is 1/1/2011 what is the required expiry date, 31-Dec-12 or 1-Jan-13? If the answer is 1-Jan-13 try with EDATE
=EDATE(IF(B2="",A2,B2),24)
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks