Got a credit card? use our Credit Card & Finance Calculators
Thanks to eyeball08,Wondergirly,bofh,johnstevens77,Bhoddhisatva, for Donating to support the site
How to add 90 days to 'today' in spreadsheet
Forum rules
Direct questions and answers, this room is not for general discussion please
Direct questions and answers, this room is not for general discussion please
How to add 90 days to 'today' in spreadsheet
Hi Folks,
Brain freeze. I have some Notice Accounts, withdraw in so many days.
I know how to make the spreadsheet show 'Today's date, but can't remember the formula for 'Today's date + 90 days).
I've done it often enough in the past, but my brain won't co-operate this morning.
Ray.
Brain freeze. I have some Notice Accounts, withdraw in so many days.
I know how to make the spreadsheet show 'Today's date, but can't remember the formula for 'Today's date + 90 days).
I've done it often enough in the past, but my brain won't co-operate this morning.
Ray.
-
- Lemon Quarter
- Posts: 3635
- Joined: November 4th, 2016, 10:00 am
- Has thanked: 556 times
- Been thanked: 1611 times
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: How to add 90 days to 'today' in spreadsheet
Nothing is tricky if you know it
we are all born knowing nothing
we are all born knowing nothing
-
- The full Lemon
- Posts: 16629
- Joined: October 10th, 2017, 11:33 am
- Has thanked: 4343 times
- Been thanked: 7535 times
Re: How to add 90 days to 'today' in spreadsheet
gryffron wrote:=TODAY()+90
tricky one that
Thanks. I did not know that.
Dod
Re: How to add 90 days to 'today' in spreadsheet
Hi,
Sadly I did know it, brain refused to recall it.
Thanks,
Ray.
Sadly I did know it, brain refused to recall it.
Thanks,
Ray.
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
-
- Lemon Half
- Posts: 8267
- Joined: November 4th, 2016, 11:20 am
- Has thanked: 919 times
- Been thanked: 4130 times
Re: How to add 90 days to 'today' in spreadsheet
Hold on a bit. "Today()+90" will change every day. You need to make that a fixed date, so for 90 days from today use "=DATE(2022,6,29)+90" which then will show 29 Sep 2022 until you change it.
TJH
TJH
-
- 2 Lemon pips
- Posts: 181
- Joined: November 5th, 2016, 8:06 am
- Has thanked: 109 times
- Been thanked: 91 times
Re: How to add 90 days to 'today' in spreadsheet
If the fixed date is already entered in another cell, I have used:
DATE(YEAR(CELL),MONTH(CELL),DAY(CELL)+90)
Where ‘CELL’ is the ref. for where the fixed date is, e.g. B11.
DATE(YEAR(CELL),MONTH(CELL),DAY(CELL)+90)
Where ‘CELL’ is the ref. for where the fixed date is, e.g. B11.
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
Re: How to add 90 days to 'today' in spreadsheet
This post and other related ones
show the excel knowledge among us is better and more precise than on a lot of excel forums
Nice one
show the excel knowledge among us is better and more precise than on a lot of excel forums
Nice one
-
- Lemon Slice
- Posts: 829
- Joined: November 4th, 2016, 6:29 pm
- Has thanked: 152 times
- Been thanked: 208 times
Re: How to add 90 days to 'today' in spreadsheet
BBLSP1 wrote:If the fixed date is already entered in another cell, I have used:
DATE(YEAR(CELL),MONTH(CELL),DAY(CELL)+90)
Where ‘CELL’ is the ref. for where the fixed date is, e.g. B11.
Is there any reason why you don't just use =B11+90 ?
-
- Lemon Half
- Posts: 7883
- Joined: November 4th, 2016, 11:24 am
- Has thanked: 7 times
- Been thanked: 3042 times
Re: How to add 90 days to 'today' in spreadsheet
tjh290633 wrote:Hold on a bit. "Today()+90" will change every day.
Yes, that's exactly the point and what is needed if you have a 90 day notice account and you want your spreadsheet to show the earliest you can get funds out any time you look at it.
If you've already put the withdrawal order in you don't need any formula: if you did it today you simply replace the =Today()+90 with the date the cell is showing, and if you did it some days ago you just log in to your bank account and look at the pending withdrawal date and stick that directly into the spreadsheet.
-
- 2 Lemon pips
- Posts: 181
- Joined: November 5th, 2016, 8:06 am
- Has thanked: 109 times
- Been thanked: 91 times
Re: How to add 90 days to 'today' in spreadsheet
Stompa wrote:BBLSP1 wrote:If the fixed date is already entered in another cell, I have used:
DATE(YEAR(CELL),MONTH(CELL),DAY(CELL)+90)
Where ‘CELL’ is the ref. for where the fixed date is, e.g. B11.
Is there any reason why you don't just use =B11+90 ?
No! Agreed more efficient as proposed.
-
- Lemon Half
- Posts: 8267
- Joined: November 4th, 2016, 11:20 am
- Has thanked: 919 times
- Been thanked: 4130 times
Re: How to add 90 days to 'today' in spreadsheet
What works in LibreOffice as well is to use =Today()+90 then click on Copy and then do ALT+E+S to convert to a fixed number.
Not sure if that works in Excel.
TJH
Not sure if that works in Excel.
TJH
-
- Lemon Quarter
- Posts: 3768
- Joined: November 6th, 2016, 10:25 pm
- Has thanked: 1185 times
- Been thanked: 1975 times
Re: How to add 90 days to 'today' in spreadsheet
I take a simple approach. On the sheet is says if it is Instant or Notice, and if Notice it says "n months" (which is no of days divided by 30) and I use my fingers to go "June now, so July August, end of Sept."
Anything in notice accounts like that is for planned expenditure, and can take a day or 2 to access, so if a couple of days either side of the notice period are critical it is probably cash in the wrong place
Paul
Anything in notice accounts like that is for planned expenditure, and can take a day or 2 to access, so if a couple of days either side of the notice period are critical it is probably cash in the wrong place
Paul
-
- Lemon Quarter
- Posts: 1976
- Joined: November 4th, 2016, 10:25 am
- Has thanked: 219 times
- Been thanked: 468 times
Re: How to add 90 days to 'today' in spreadsheet
tjh290633 wrote:What works in LibreOffice as well is to use =Today()+90 then click on Copy and then do ALT+E+S to convert to a fixed number.
Not sure if that works in Excel.
TJH
In Excel, it's CTRL-C then ALT-E, S, V - or Paste Special, Values
-
- Lemon Slice
- Posts: 470
- Joined: November 8th, 2016, 1:42 pm
- Has thanked: 223 times
- Been thanked: 210 times
Re: How to add 90 days to 'today' in spreadsheet
chas49 wrote:tjh290633 wrote:What works in LibreOffice as well is to use =Today()+90 then click on Copy and then do ALT+E+S to convert to a fixed number.
Not sure if that works in Excel.
TJH
In Excel, it's CTRL-C then ALT-E, S, V - or Paste Special, Values
Quicker (if you're right handed:-
Left hand: CTRL-C, Right hand (on mouse): right click, left click on 'paste values'
-
- Lemon Half
- Posts: 6050
- Joined: May 30th, 2021, 6:01 pm
- Has thanked: 1843 times
- Been thanked: 2067 times
-
- Lemon Half
- Posts: 6059
- Joined: November 5th, 2016, 9:05 am
- Has thanked: 20 times
- Been thanked: 1413 times
Re: How to add 90 days to 'today' in spreadsheet
Dod101 wrote:Thanks. I did not know that.
Spreadsheets store dates as the number of days since 31/12/1899. I think it was intended that day 1 was 1st January 1900, but some designer forgot that Febrauary 1900 was not a leap year. That bug has had to be locked into spreadsheets ever since to enable data to be standardised.
Elesewhere I've seen the count start from the calandar change in the 1700s.
Seemingly libreoffice supports negative numbers, thus enabling dates prior to that to be stored. I think it also allows for calendar changes. Certainly the day before 01/01/0001 is 31/12/-0001
Who is online
Users browsing this forum: No registered users and 19 guests