Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to johnstevens77,Bhoddhisatva,scotia,Anonymous,Cornytiv34, for Donating to support the site

How to add 90 days to 'today' in spreadsheet

Straight answers to factual questions
Forum rules
Direct questions and answers, this room is not for general discussion please
raybarrow
Lemon Slice
Posts: 437
Joined: November 6th, 2016, 8:14 am
Been thanked: 83 times

How to add 90 days to 'today' in spreadsheet

#510534

Postby raybarrow » June 29th, 2022, 9:32 am

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.

gryffron
Lemon Quarter
Posts: 3605
Joined: November 4th, 2016, 10:00 am
Has thanked: 550 times
Been thanked: 1584 times

Re: How to add 90 days to 'today' in spreadsheet

#510538

Postby gryffron » June 29th, 2022, 9:38 am

=TODAY()+90

tricky one that :twisted:

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: How to add 90 days to 'today' in spreadsheet

#510543

Postby pje16 » June 29th, 2022, 9:44 am

Nothing is tricky if you know it
we are all born knowing nothing :D

Dod101
The full Lemon
Posts: 16629
Joined: October 10th, 2017, 11:33 am
Has thanked: 4343 times
Been thanked: 7534 times

Re: How to add 90 days to 'today' in spreadsheet

#510550

Postby Dod101 » June 29th, 2022, 9:53 am

gryffron wrote:=TODAY()+90

tricky one that :twisted:


Thanks. I did not know that.

Dod

raybarrow
Lemon Slice
Posts: 437
Joined: November 6th, 2016, 8:14 am
Been thanked: 83 times

Re: How to add 90 days to 'today' in spreadsheet

#510554

Postby raybarrow » June 29th, 2022, 10:01 am

Hi,

Sadly I did know it, brain refused to recall it.

Thanks,
Ray.

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: How to add 90 days to 'today' in spreadsheet

#510560

Postby pje16 » June 29th, 2022, 10:15 am

I guess we all have days or moments like that :lol:

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: How to add 90 days to 'today' in spreadsheet

#510610

Postby tjh290633 » June 29th, 2022, 11:43 am

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

BBLSP1
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

#510640

Postby BBLSP1 » June 29th, 2022, 12:47 pm

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.

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: How to add 90 days to 'today' in spreadsheet

#510647

Postby pje16 » June 29th, 2022, 12:52 pm

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

Stompa
Lemon Slice
Posts: 825
Joined: November 4th, 2016, 6:29 pm
Has thanked: 151 times
Been thanked: 208 times

Re: How to add 90 days to 'today' in spreadsheet

#510652

Postby Stompa » June 29th, 2022, 1:03 pm

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 ?

mc2fool
Lemon Half
Posts: 7812
Joined: November 4th, 2016, 11:24 am
Has thanked: 7 times
Been thanked: 3017 times

Re: How to add 90 days to 'today' in spreadsheet

#510660

Postby mc2fool » June 29th, 2022, 1:43 pm

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. ;)

BBLSP1
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

#510666

Postby BBLSP1 » June 29th, 2022, 1:50 pm

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.

tjh290633
Lemon Half
Posts: 8208
Joined: November 4th, 2016, 11:20 am
Has thanked: 913 times
Been thanked: 4096 times

Re: How to add 90 days to 'today' in spreadsheet

#510784

Postby tjh290633 » June 29th, 2022, 10:59 pm

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

DrFfybes
Lemon Quarter
Posts: 3731
Joined: November 6th, 2016, 10:25 pm
Has thanked: 1171 times
Been thanked: 1964 times

Re: How to add 90 days to 'today' in spreadsheet

#510843

Postby DrFfybes » June 30th, 2022, 10:57 am

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

chas49
Lemon Quarter
Posts: 1935
Joined: November 4th, 2016, 10:25 am
Has thanked: 216 times
Been thanked: 457 times

Re: How to add 90 days to 'today' in spreadsheet

#510856

Postby chas49 » June 30th, 2022, 11:37 am

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

Gaggsy
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

#510858

Postby Gaggsy » June 30th, 2022, 11:46 am

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'

pje16
Lemon Half
Posts: 6050
Joined: May 30th, 2021, 6:01 pm
Has thanked: 1843 times
Been thanked: 2066 times

Re: How to add 90 days to 'today' in spreadsheet

#510862

Postby pje16 » June 30th, 2022, 12:00 pm

I have a mouse :lol:

Alaric
Lemon Half
Posts: 6032
Joined: November 5th, 2016, 9:05 am
Has thanked: 20 times
Been thanked: 1398 times

Re: How to add 90 days to 'today' in spreadsheet

#510878

Postby Alaric » June 30th, 2022, 1:15 pm

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


Return to “Does anyone know?”

Who is online

Users browsing this forum: No registered users and 10 guests