I am trying to determine a formula that will tell me what the date will be 61 days and 90 days from a selected date. For example:
A1: 04/11/2014
A2: (Date 61 days from date in A1)
A3: (Date 90 days from date in A1)
Is this possible??
I am trying to determine a formula that will tell me what the date will be 61 days and 90 days from a selected date. For example:
A1: 04/11/2014
A2: (Date 61 days from date in A1)
A3: (Date 90 days from date in A1)
Is this possible??
Last edited by myoung5149; 04-11-2014 at 02:28 PM.
In A2, put =A1+61
In A3, put =A1+90
Format both cells as a Date.
OR if you need to add number of month to A1 you can use this formula
in A2 and drag formula down
=EDATE($A$1,ROWS($A$1:A2))
A 1 4/11/2014 2 6/11/2014 3 7/11/2014
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Great! This was able to work for me, but is there any way to make it so if A1 is blank, so are A2 and A3? They are defaulting to 3/1/1900 and 3/30/1900
Try
=IF(A1="","",A1+61)
=IF(A1="","",A1+90)
Perfect! That worked! Thanks for the help!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks