ctsammon
ctsammon
Reactions
Discussions
- Hello - I have 3 cells in my sheet, "Assigned To" "Date Completed" "Status" I need a formula that says if "Assigned To" is any text, then then "Status" would = "Assigned", and once someone puts a date…
- Excel has a new formula in which you can define workdays by row (workday.intl). I am having to switch to Excel just for this function as I have different shifts working different number of days per we…
- Hello - I currently am calculating "days safe" for each department and shift. Days safe is currently calculating "todays date" - "date of last accident". However, some shifts only work 4 days a week a…
- I'm looking for a simple formula to generate my fiscal year using the date entered in the "Date of Accident/Incident" column. Fiscal Year Start: Feb 1st Fiscal Year End: Jan 31 Outcome desired: If tod…
- Need some assistance. Our fiscal months/years are a little wonky :). I have a sheet "Master Fiscal Year Dates" which provides the exact dates for each fiscal year, period, and quarter. In my accident …
- I have two columns "Associate Name" which contains a list of names, and a corresponding list of birthdates "Date of Birth", both ever expanding. I would like to have a column that counts the number of…
- Hi . I have a column which contain dates. Is there a formula that would: Return the largest gap between the dates in the column? Return the dates? My column contains dates of call logs. I want to see …
- In the above example, I need a formula to calculate how long (in hours) it took to report an incident. So Date and Time reported - Date and Time of incident. In the above example, row 1 report time (h…
- I have a column titled "Effective Date". I want to have 3 other columns populated based on the date entered in "Effective Date". 1st column: "Period" 2nd column: "Quarter" 3rd column "Fiscal Year". Ou…
- Sheet 1 has a column "Date Conducted". Another column "Status" with dropdown options "Safe" and "Improve" Summary Sheet has two columns, "Start Date" and "End Date". On the summary sheet, I'm trying t…
