Previous Topic Next Topic

Excel 2003 days before a certain date

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


Related:

2 responses

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

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
Unable to change date format in Excel
rznbyz -
Tobby -

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

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

2 responses