Previous Topic Next Topic

Excel 2003 days before a certain date

Solved/Closed
news12kim Posts 2 Registration date Friday September 14, 2012 Status Member Last seen October 5, 2012 - Sep 14, 2012 at 11:24 AM
news12kim Posts 2 Registration date Friday September 14, 2012 Status Member Last seen October 5, 2012 - Oct 5, 2012 at 11:37 AM
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 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 15, 2012 at 12:00 AM
=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)
0
Answer 2 / 2
news12kim Posts 2 Registration date Friday September 14, 2012 Status Member Last seen October 5, 2012
Oct 5, 2012 at 11:37 AM
Thanks! that worked...
0

Similar discussions

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
this account will be disabled in 28 day you only have 28 days left to request a
Chandrakantmahire -
Treasurelove -

2 responses
You disagreed with the decision facebook
MDHamijuddin -
HelpiOS -

1 response
This account will be disabled in 1 day Are you sure that you want to log out? Y
Usman -
dwebb -

1 response