The following formula is in cell A3:
A3=IF(A2="X",A1+365,"")
Rather than A3 displaying only 1 year, I would like for it to update after that day occurs to =A1+730, and then A1+1095, and so on.
Thanks for the help.
The following formula is in cell A3:
A3=IF(A2="X",A1+365,"")
Rather than A3 displaying only 1 year, I would like for it to update after that day occurs to =A1+730, and then A1+1095, and so on.
Thanks for the help.
Last edited by stevedes7; 01-02-2010 at 09:53 PM.
Perhaps =IF(A2 <> "x", "", A1+ CEILING(TODAY() - A1, 365) )
Entia non sunt multiplicanda sine necessitate
Great. That's it. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks