MSalas - profile

MSalas · Feb 07, 2024

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

MSalas · Feb 07, 2024

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

MSalas · Feb 08, 2024

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

MSalas · Feb 08, 2024

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

MSalas · Feb 08, 2024

You were right. Now just getting it the right time zone haha. Thank you very much. I thought I had done this but apparently not.

MSalas · Feb 07, 2024

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., ...

User Statistics

User Activity

Using Dates Field to Generate Text within a month

DATEADD

Re: Using Dates Field to Generate Text within a month

Re: Using Dates Field to Generate Text within a month

Re: DATEADD

Re: DATEADD