nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Formula for finding the first and last days of a year

jwestberry83396

I need to be able to calculate the first and last days of the year based upon the current date. Can someone help me out?

Find more posts tagged with

Formulas

Project Management

Comments

L_123

You don't really need to update anything other than the year right?

=date(year(today()),1,1) is the first day of the year

=date(year(today()),12,31) is the last day of the year

jwestberry83396

Correct,

Perfect, Thank you!

Sign in to join the conversation!

Quick Links

Trending discussions

How to set up a rule depending on what is selected in a previous column
How can I set up instructions from an earlier coloumn, if someone has selected Bonus A this means that a payment is due 6 months after the start date so need to show this date in the column
Start Date Formulas not appearing in reports
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…