So my challenge may be in my how I have my dates setup. Essentially what I'm trying to do is to utilize a date to create text based on the current month. I think an example could better explain this, e.g., I have a date that is 4/1/2024 and I'd like ...
I'm having trouble with using the DATEADD function (and yes totally new at this). I'm trying to add 3 months to a date in another column. I've technically gotten the formula to work but it's not quite getting the desired date. So for example if my da...
So here is my table of data. Let's pretend it is the month of April 2024. The blacked out part are client names. The column in yellow is where I'd like to place a formula that would generate the text of either "graph", "annual" or "summary" based on ...
This may work if I add additional columns with the graph dates (which is something I may need to do). I was hoping that I could create a formula that'll essentially be able to 'default' to the text 'Graphs' and then change to 'Summaries' the months t...
Time zones are the same. I think what I need is to add 1 day. I think the formula is correct: DATEADD ({Annual Due}, 3, 'months'). So it's adding 3 months, but instead of going to the exact date three months later it's going to the day before, e.g., ...
