for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 102 watchers

SPR Sep 2023 6:31pm, 22 Sep 2023 42,716 posts	Quote Pin SPR Ah, re-read your post and you did it without EDATE. That should work well enough.
SPR Sep 2023 6:49pm, 22 Sep 2023 42,717 posts	Quote Pin SPR Confirmed the EDATE version works once the correct syntax is used.
um Sep 2023 7:03pm, 22 Sep 2023 7,731 posts	Quote Pin um SPR - I must admit I didn't fully understand what you meant by (eg) YEAR(EDATE(START DATE,-1)) So I reverted to something I knew.
Fields Sep 2023 7:04pm, 22 Sep 2023 9,944 posts	Quote Pin Fields Thanks
Fields Sep 2023 7:06pm, 22 Sep 2023 9,945 posts	Quote Pin Fields Sorry I didn’t get the tag done thanks SPR and um I will put that on my list of things to look at on Monday
SPR Sep 2023 7:42pm, 22 Sep 2023 42,719 posts	Quote Pin SPR You're welcome Fields um EDATE -1 just takes the date back a month which is why it can deal with the year bit.
Fields Sep 2023 9:18am, 28 Sep 2023 9,972 posts	Quote Pin Fields Finally had a chance to check this and it works a treat
sallykate Nov 2023 10:47pm, 4 Nov 2023 12,543 posts	Quote Pin sallykate Not Excel but I wonder if anyone here can help. I have been trying to help my daughter with some school work. She's created a plot of a shape, so I have coordinates defining the shape. Now she has to model it on a site called Desmos. Her teacher suggested using Google Sheets to derive the polynomial equation for the curves which make up the shape. It's a guitar, so not one regular shape; I'm doing a few points at a time. This works fine for some of the segments but for others it's way out, and I can't figure out why. I'm generally taking the polynomial to the third degree, unless it starts including e, in which case Desmos doesn't seem to be able to cope. Am aware that this might be total gibberish to you all but asking just in case!
EdJ Nov 2023 7:58am, 5 Nov 2023 715 posts	Quote Pin EdJ Could you show us what shape(s) she is trying to draw. I'm intrigued!
um Nov 2023 8:38am, 5 Nov 2023 7,855 posts	Quote Pin um I've never used Desmos, but share what you can and I'll have a play. (It's that or leaf raking!) Or check with my maths teacher son later, if he knows or uses it