Excel 2003 days before a certain date [Solved/Closed]

Report
Posts
3
Registration date
Friday September 14, 2012
Status
Member
Last seen
October 5, 2012
-
Posts
3
Registration date
Friday September 14, 2012
Status
Member
Last seen
October 5, 2012
-
Hello,

I am making a spreadsheet which has, for example, a given date of 1/1/2012.

When I enter that number into cells A1, I want it to return a date 105 days prior in to cell E1, and 45 days prior than the given date. But...this formula will only be applicable if the cell value in B1 is "SE".

thank you sooo much


2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
=TEXT(IF(B1="SE",A1-105,""),"dd/mmm/yyyy")
for cell E1

use similar type for less then 45(you have not said in which this is located)
Posts
3
Registration date
Friday September 14, 2012
Status
Member
Last seen
October 5, 2012

Thanks! that worked...