Formula Needed

C

Chascy

New Member
Joined
Aug 18, 2007
Messages
2
I need the formula that would set up a date (will vary) in, lets say column D and then have column C be a date that is 45 days earlier.

Also, does Excel's formulas stay the same if using a newer version (Vista?)

Example:
Column C Column D
09/17/2007 11/1/2007
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Sort by date Sort by votes
dave3009

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,128
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Mobile
  3. Web
Hi

Welcome to the board

Can you not just delete 45 from the date in question

Code: 
=C1-45

For 45 days earlier

HTH


Dave
 
Upvote 0
Y

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi chascy:

Welcome to MrExcel Board!

In the following I have elaborated what Dave3009 has proposed ...

<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
BCDE
19/17/200711/1/2007
Sheet7


</body></html>

This should work in all versions of EXCEL.
 
Upvote 0
C

Chascy

New Member
Joined
Aug 18, 2007
Messages
2
Formula Still Needs Tweeking

Thank you for your assistance. I neglected to mention I'm fairly new at Excel and better in English than Math. :)

Yogi/Dave, when I plug in that formula in Cell C. It just sits there. It does not convert it.

I should go to formulas, yes? I did and chose "Date and Time". The drop down box gives me a plethora of choices. I do not know where to go from here.

Charlynn Wise
 
Upvote 0
Y

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Charlynn:

If you key-in 11/1/07 in cell D1, it will be entered as a DATE in cell D1;

in cell you should key-in ...

=D1-45

then press the ENTER key.

If it works for you now ... GREAT -- otherwise post back what is the result in cell C1, and then let us take it from there.
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
Formulas and Conditional Formatting Using Dates
Replies
1
Views
386
awoohaw
A
P
  • Solved
Help in Formula
Replies
5
Views
87
awoohaw
A
S
  • Solved
Date formula
Replies
4
Views
90
Peter_SSs
Peter_SSs
K
  • Question
Revenue ramp up and ramp down formula needed
Replies
0
Views
56
KSU1016
K
M
  • Solved
Need to highlight cell with date
2
Replies
14
Views
130
Micron
M

Forum statistics

Threads
1,191,691
Messages
5,988,111
Members
440,126
Latest member
duque00

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top