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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Sort by date Sort by votes
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
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
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
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

Kellie220
  • Solved
Formula for calculating different dates/ VBA
Replies
3
Views
157
awoohaw
awoohaw
J
  • Question
Formula to move information to calendar
Replies
0
Views
82
jc352
J
W
  • Question
I need a Formula to Autofill the date based on the Date, Specific Value, and then no of days
Replies
6
Views
162
Alex Blakenburg
A
Ramballah
  • Solved
Finding the first certain value with conditions
2
Replies
18
Views
294
mumps
mumps
N
  • Question
Concatenate two columns keeping date and time formatting
Replies
5
Views
249
Fluff
Fluff

Forum statistics

Threads
1,214,965
Messages
6,122,500
Members
449,090
Latest member
RandomExceller01

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
Back
Top