LinkBack URL
About LinkBacks
Hi. The current formula that I have can only calculate a date that is 5 months ahead of the cell date:
=DATE(YEAR(A1),MONTH(A1)+5,DAY(A1))
Is there a way to modify the formula to calculate a date that is 5 months ahead of the computer's system time?
Hi. The current formula that I have can only calculate a date that is 5 months ahead of the cell date:
=DATE(YEAR(A1),MONTH(A1)+5,DAY(A1))
Is there a way to modify the formula to calculate a date that is 5 months ahead of the computer's system time?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks