date functions

I have an Excel table with a field called TradingDay that simply stores Boolean values of whether a given date is a trading day. I used the formula described here to get whether the date is a trading day or not: https://exceljet.net/formula/date-is-workday Now I want to create a new field...

Hi I am preparing the Project Plan and in which i need arrive at a day when task is suppose to happen. E.g BRD Completed - Mon,20,Aug,18 Submit BRD for BS-Review(cut off is every Friday or Tuesday) Review Date: Every Monday and Thursday I have used following formula H29 = Mon,20,Aug,18...

Hi all, please view image to understand what i'm talking about! I imported billing dates into my master file (column B), using logic in excel I broke up the string of the billing period to properly identify the Start and End dates. Now I would like to convert these strings in columns D and...

Good day, I trust someone has bumped into this kind of exercise before and would be able to assist in solving my problem. I have the following example data set: <tbody> <tbody> 1 SA Rand vs US Dollar 2 3 Weighted average of the banks' daily rates at approximately 10:30 am...

I am looking to SUMIFS the costs in Column I when the values in Column H are ,<=TODAY() and >=TODAY()+90, and value in column M is "DTB" (with DTB to be able to change based on the individual members of team). I also do not want to have to keep going back and changing cell range to include all...

Hi, I have the start date of an event (say 20/03/2012) and it occurs every 6 months. How do I get the next date of occurrence, in this year in excel as well as the date the event last occurred.

Hi guys, I have two spreadsheets, one gives me the beginning and end of civil twilight as a measure of day vs. night. The spreadsheet has Date/Time in the first column, and the value 45 in the 2nd column when it is night. The second spreadsheet has also 2 columns with date/time and body...

I use the NETWORKDAYS function a lot, and it is very useful. But how can I determine a future date that is so many workdays after the start date? Example: what date is 27 workdays after September 15?

I am looking for help to automatically add timestamps (date of entry) to each row in a worksheet. My goal is to test that there is data in cells in columns A, B and D, and when found, to enter the datestamp automatically after the user leaves cell D (and the others are filled) - the datestamp...