I'm looking to create a calculation to display the following Sunday in day-month format based on the current date (=NOW()).  How can I do that?
120975
I need a formula that will always return the next specified day of the week.  For instance   IF(A1="A",RETURN NEXT FRIDAY, IF(A1="B",RETURN NEXT TUESDAY.....ETC   The reason I need this is because I have a group of accounts and each of them has a specified delivery date, so if an account has been assigned to group A they will take delivery on Mondays, and if they have been assigned to group B, delivery will be Tuesdays etc.    I think from these examples the formula will result in a different day and date dependent on what day "today" is. What I need is for each account in group A to default to the next Monday, regardless of what day of the week it is currently. So group A would be today+4 if it is Monday but today+3 if it is Tuesday. I hope this makes sense.
18763
I want a formula that will return a date that depends on the date in another cell, but modified by the day of the week of the date in that cell.   If cell A1 has a date value that is a Sunday, Monday, or Tuesday, I want cell A2 to return the date of the Friday before (e.g. if A1 is Monday 16 Oct 2017, A2 would return Friday 13 Oct 2017). If the date in cell A1 is Wednesday through Saturday then the date in cell A2 would be two days prior to the day (e.g. If A1 is Thursday 19 Oct 2017 then cell A2 would return a date of Tuesday 17 Oct 2017).   I want the formula to do all of the above calculations in one formula.
29212
Anyone know a simple way using Java calendar to subtract X days from a date?  I have not been able to find any function which allows me to directly subtract X days from a date in Java. Can someone point me to the right direction?
20073
I've been using this function but I'd like to know what's the most efficient and accurate way to get it.  function daysInMonth(iMonth, iYear) {    return 32 - new Date(iYear, iMonth, 32).getDate(); }
116355
In an Excel spreadsheet, I'd like to automatically update a cell with the current date and time when another cell is changed (like an update timestamp).  There is a timestamp for each row. I'd like to update them as soon as one of the preceding cells in the row is updated.  Do you have any pointers on how to do that?
40544
Given:  DateTime.UtcNow   How do I get a string which represents the same value in an -compliant format?  Note that ISO 8601 defines a number of similar formats. The specific format I am looking for is:  yyyy-MM-ddTHH:mm:ssZ
34616
So I have a date field that needs to be a future date when the item is created.  The formula I have set up for that is:  =[Date Required]&gt;TODAY()   This works well however I am running into an issue.  If the department is updating a List item after the Future Date it will still provide an error.  Is there a formula to use when the column validation can only be active when a new item is being created and not edited?    Thank you
107398
I am making my own title page. I'd like Latex to display the date automatically using \date{\today} but this does not work, since I am not doing \maketitle  So instead of setting the date manually myself and worry about updating it, is there a way to make Latex use \date{\today} in my own title page?  MWE  \documentclass[12pt,notitlepage]{article}% %\usepackage{datetime} did not help \newcommand*{\myTitle}{\begingroup  \centering  \vspace*{\baselineskip}   {\LARGE My Title}% Title \vspace*{1\baselineskip}     \scshape % Small caps My project     \vspace*{1\baselineskip} University of Main Street\\[\baselineskip]  \vspace*{5\baselineskip}   Written by \\[\baselineskip] {\Large John Due\par}      \vspace*{1\baselineskip} \scshape \date{\today} %\date{\currenttime}  does not work      \endgroup}  \begin{document} \pagestyle{empty}  \myTitle \clearpage  This is my report \end{document}     I googled and gave up after 15 minutes search.
109802
I'm specifically looking to change the formatting in two places:  On the desktop, the date/time reads "Sat 21:05". I would like it to read "23-Jul-11 21:05" or "23 Jul 11 21:05". In other words, I want to change the display of the day of week to display the day, short month name, and short year.  On the login screen, the date/time reads "Sat 9:06 PM". I would like to change it to either the same as the desktop ("23-Jul-11 21:05" or "23 Jul 11 21:05") or the preferred display of the full date in the format ("Saturday, 23 July 2011 21:05") where the full day, date, full month, full year, and time (in 24-hour format) is displayed.  I don't see any options to adjust this. I would suspect it's possible, but I'm not sure what config file it would be in or what options I would adjust.
60087
I'm attempting to set up an email template based on the time of day to begin an email with either a "Good Morning" or a "Good Afternoon" greeting based on the time of day that the email was sent.  I see that the {!Now()} function provides me with the current date and time. However, I'm rather new to Salesforce, and haven't been able to figure out how to capture just the time for a comparison in a conditional statement something like Good {!if {!Now()} &lt; "12:00 AM", "Morning", "Afternoon"}.   I've done quite a bit of searching, and haven't yet been able to find an answer to this question. Any help or reference material would be most appreciated. I've already scoured the Salesforce help pages (including the  page), and browsed the internet for a solution.
94071
How do I get the difference in days between 2 dates in SQLite? I have already tried something like this:  SELECT Date('now') - DateCreated FROM Payment   It returns 0 every time.
82844
I would like to create a reminder on Google Calendar every month on the 15th, but if the 15th in that month is a Friday/Saturday, I want it automatically to set it to the closest Sunday/Thursday. Is this possible?
70243
I'm trying to adjust this code so that I can jump to today's date which are all across row 2 in my spreadsheet.  function onOpen() {  var ss = SpreadsheetApp.getActiveSpreadsheet();  var sheet = ss.getActiveSheet();  var range = sheet.getRange("A:A");  var values = range.getValues();    var day = 24*3600*1000;    var today = parseInt((new Date().setHours(0,0,0,0))/day);    var ssdate;   for (var i=0; i&lt;values.length; i++) {    try {      ssdate = values[i][0].getTime()/day;    }    catch(e) {    }    if (ssdate &amp;&amp; Math.floor(ssdate) == today) {      sheet.setActiveRange(range.offset(i,0,1,1));      break;    }      } }    is from Marshmallow  I tried changing sheet.getRange("A:A") to sheet.getRange("2:2") and sheet.getRange("C2:PB2") but neither work.
54712
In my scenario I'm trying to display a flag (Font Awesome icon) in Views Global Text Field if another field in the same row of a type "Date" has a value of, say, a week from now. I tried  but it has some bugs with filters I'm using, so I thought that using the above approach would be better.
12134
Is there a way using Python's standard library to easily determine (i.e. one function call) the last day of a given month?  If the standard library doesn't support that, does the dateutil package support this?
106787
Suppose I have a date, i.e. year, month and day, as integers. What's a good (correct), concise and fairly readable algorithm for computing the   of the week the given date falls into? I have come across some truly horrendous code that makes me think surely there must be a better way.  I'm looking to do this in Java but psuedocode for any kind of object-oriented language is fine.
46612
Given a week number, e.g. date -u +%W, how do you calculate the days in that week starting from Monday?  Example rfc-3339 output for week 40:  2008-10-06 2008-10-07 2008-10-08 2008-10-09 2008-10-10 2008-10-11 2008-10-12